取webconfig里的方法: var strA = ConfigurationManager.AppSettings["[you key1]"]; var strB = ConfigurationManager.AppSettings["[you key2]"];insert into [数据库1的名字].[表名] select tb2.col1,tb2.col2,tb2.col3,strA,strB from [数据库2的名字].[表名] where [你的查询条件]
insert into B(a,b,c) select a,b,c from a a 原 表名称 b目标表
把你的需求说清楚
var strA = ConfigurationManager.AppSettings["[you key1]"];
var strB = ConfigurationManager.AppSettings["[you key2]"];insert into [数据库1的名字].[表名]
select tb2.col1,tb2.col2,tb2.col3,strA,strB
from [数据库2的名字].[表名]
where [你的查询条件]
string sql="insert into Tb select a,b,c,"+s+" from Tb2";
再使用Transaction 或TransactionScope
using(SqlConnection con = new SqlConnection(""))
{
con.Open();
SqlTransaction myTran = con.BeginTransaction();
SqlCommand myCom = new SqlCommand();
}