34,588
社区成员
发帖
与我相关
我的任务
分享
DECLARE @a TABLE(ia INT, na INT, x INT NULL)
INSERT @a SELECT 1, 5, NULL
UNION ALL SELECT 2 , 20,NULL
UNION ALL SELECT 3 ,22,NULL
DECLARE @b TABLE(ib INT, nb INT)
INSERT @b SELECT 1, 9
UNION ALL SELECT 2 , 18
UNION ALL SELECT 3 ,19
create procedure A_UPDATE
@nb int
as
update a set a.na=@nb,ia=(select count(*) from na)
where @nb=(select nb from b where nb<na)
exec A_UPDATE