本文介绍了从临时表读取并插入普通表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我们如何从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


这篇关于从临时表读取并插入普通表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-18 22:41
查看更多