C#中如何建立临时表并插入数据？

DataTable oldDt = GetDataTable()

DataTable newDt = oldDt.Clone() //此处就可以将旧DataTable结构赋给新DataTable

foreach(DataRow oldDr in oldDt.Rows)

{

/***

执行filter.....

*******/

DataRow newDr = newDt.NewRow() //新表创建新行

newDr.ItemArray = oldDr .ItemArray//旧表结构行赋给新表结构行

newDt.ImportRow(oldDr )

}

试试这样

select identity(int) as id,prerec .* into #tmp_prerec_pp from prerec where deptno='JINA000000' and paydate='20100417'

select * from #tmp_prerec_pp

---