不需用游标
1.
UPDATE stuonline
SET stuonline.endtime = getdate()
FROM stuonline
INNER JOIN table1 ON table1.sono=stuonline.sono
2.
insert into stulogin select * from stuonline
3.
delete FROM stuonline
1.
UPDATE stuonline
SET stuonline.endtime = getdate()
FROM stuonline
INNER JOIN table1 ON table1.sono=stuonline.sono
2.
insert into stulogin select * from stuonline
3.
delete FROM stuonline
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货