Tuesday, November 24, 2009

拭目以待

You can fool all the people some of the time, some of the people all the time, but you cannot fool all the people all the time.

Wednesday, November 04, 2009

Dynamic SQL Excute

declare @tablename char(10)
declare @columnname char(10)
set @tablename='myTable'
set @columnname='myColumn'
execute('select * from ' + @tablename + ' order by ' + @columnname)

Tuesday, November 03, 2009

Copy selective columns of data table to another datatable - VB.NET Articles, samples and tutorials

Dim DestTable As DataTable = new DataTable

Dim NewColumns() As String={"EmpID","FirstName "}

DestTable = sourceTable.DefaultView.ToTable("TableName", false, strColsToExport)

Blog Archive