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)
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)
Dim NewColumns() As String={"EmpID","FirstName "}
DestTable = sourceTable.DefaultView.ToTable("TableName", false, strColsToExport)
Subscribe to:
Posts (Atom)
Blog Archive
- June (1)
- April (2)
- April (1)
- August (1)
- April (1)
- March (1)
- February (1)
- March (1)
- February (2)
- August (1)
- April (1)
- March (1)
- February (2)
- November (3)
- September (1)
- August (1)
- June (1)
- April (1)
- March (1)
- February (5)
- January (1)
- August (1)
- July (1)
- January (2)
- August (1)
- June (1)
- March (4)
- February (3)
- January (3)