110,528
社区成员
发帖
与我相关
我的任务
分享
using (SqlConnection conn = new SqlConnection(DbUtils.cs))
{
conn.Open();
SqlTransaction Transaction = conn.BeginTransaction();//开启事务
using (SqlBulkCopy BulkCopy = new SqlBulkCopy(conn, SqlBulkCopyOptions.Default, Transaction))
{
try
{
BulkCopy.BulkCopyTimeout = 360;
BulkCopy.DestinationTableName = TableConvention.Resolve(new Customer_Deposit_Data());//目标表
BulkCopy.WriteToServer(ds.Tables[i]);
BulkCopy.ColumnMappings.Clear();
Transaction.Commit();//事务提交
}
catch
{
Transaction.Rollback();//事务回滚
}
finally
{
BulkCopy.Close();
Transaction.Dispose();//事务释放
conn.Close();
}
}
}
select ckzh from Customer_deposit where khjlh='000890'
select a.* from Customer_Deposit_data a
inner join Customer_deposit b on a.ckzh = b.ckzh
where a.sjrq='2016-05-18'
and b.khjlh='000890'
如果超时,就打开执行计划检查所需索引有没加全select A.* from Customer_Deposit_data A, Customer_deposit B where A.sjrq='2016-05-18' and
A.ckzh=B.ckzh AND B.khjlh='000890'