Script(s)

technology as-is

August 28, 2015
by gchandra
0 comments

Hive : Create database in different folder

When database is created in Hive, its usually saved in default folder  /user/hive/warehouse/yourdabase.db If alternate location is needed, then create database <yourdatabase> location  ‘/db/path/yourdatabase.db’    [single quotes]  

June 11, 2008
by gchandra
8 Comments

How to Save Column Names with Results : SQL Server 2005

Whether you are copying query output from SQL Server Management Studio or Saving result as .csv file, if you need to save the column name or column header along with result.. here is simple option you have to enable. Goto … Continue reading

January 7, 2008
by gchandra
2 Comments

Asp.Net Filter Datatable by Column

Filter Datatable by Rows If you need to get subset of a big dataset into datatable Rowwise … [sourcecode language=’vb’] Dim dtEmp as DataTable Dim dsEmployee as New DataSet dsEmployee = someobject.getdata()  ‘dataset can be populated in many ways which … Continue reading

November 15, 2007
by gchandra
2 Comments

Copy Datatable from one Dataset to another Dataset

 Copying a datatable from one dataset  to another was not that straightforward as I thought. [sourcecode language=’vb’] Dim dsSource As New DataSet Dim dsDestination As New DataSet ‘Your way to get data from XML or DB. dsSource = object.getdata() dsDestination … Continue reading

February 15, 2006
by gchandra
0 comments

SQL2000 : Drop Database Contents from Query Analyzer

U : Table P : SP PK : Primary Key UQ : Unique Constraint F : Foreign Key FN : Functions D : Default To see the list of User Create Items — SELECT * FROM sysObjects WHERE xType in … Continue reading