先取数据到临时表
select * into #lug_bill_temp from [192.168.208.32\sql2008].expressnb.dbo.lug_bill
where update_status in(0,2)
再更新
update [192.168.208.32\sql2008].expressnb.dbo.lug_bill set update_status = 1
from [192.168.208.32\sql2008].expressnb.dbo.lug_bill l,#lug_bill_temp t
where t.bill_id = l.bill_id and t.invoice = l.invoice
在更新时速度很慢,不知什么原因会引起这个.
select * into #lug_bill_temp from [192.168.208.32\sql2008].expressnb.dbo.lug_bill
where update_status in(0,2)
再更新
update [192.168.208.32\sql2008].expressnb.dbo.lug_bill set update_status = 1
from [192.168.208.32\sql2008].expressnb.dbo.lug_bill l,#lug_bill_temp t
where t.bill_id = l.bill_id and t.invoice = l.invoice
在更新时速度很慢,不知什么原因会引起这个.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货