本文介绍了从临时表读取并插入普通表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我们如何从sql 2008中的临时表插入到普通表中?
我已将查询写为
插入表1中的值(字段1,字段2)从## TmpTable
How can we insert into a normal table from temp tables in sql 2008?
I have written query as
insert into Table1 Values (Field1, Field2) Select Fld1, Fld2 From ##TmpTable
推荐答案
using (SqlConnection connSource = new SqlConnection(connectionstring))
using (SqlCommand cmd = connSource.CreateCommand())
using (SqlBulkCopy bcp = new SqlBulkCopy(connectionstring))
{
bcp.DestinationTableName = "table1";
cmd.CommandText = "SELECT Fld1, Fld2 FROM ##TmpTable";
cmd.CommandType = CommandType.Text;
connSource.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
bcp.WriteToServer(reader);
}
}
VB.net转换后的代码,我不是VB.net开发人员,请仅了解此想法并继续.
VB.net converted code, i''m not VB.net developer, please get only the idea and proceed.
Using connSource As New SqlConnection(connectionstring)
Using cmd As SqlCommand = connSource.CreateCommand()
Using bcp As New SqlBulkCopy(connectionstring)
bcp.DestinationTableName = "table1"
cmd.CommandText = "SELECT Fld1, Fld2 FROM ##TmpTable"
cmd.CommandType = CommandType.Text
connSource.Open()
Using reader As SqlDataReader = cmd.ExecuteReader()
bcp.WriteToServer(reader)
End Using
End Using
End Using
End Using
这篇关于从临时表读取并插入普通表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!