阅读背景:

嵌套更新SQL Server和SELECT

来源:互联网 

I need to have a query as below:

我需要查询如下:

SELECT top (1) @AddressRepeatNum=a.CheckNumber FROM(
UPDATE dbo.SearchList SET CheckNumber=CheckNumber+1 
OUTPUT inserted.CheckNumber AS CheckNumber 
WHERE PageAddress=@Address and CheckNumber<6
) as a
S



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: