SET ROWCOUNT 4 -- 指定4行(和 TOP N 有點類似)
GO
UPDATE titles
SET advance = 5000
WHERE advance >= 5000 -- 只能改變指定的4行
GO
SET ROWCOUNT 0
select * from titles WHERE advance >= 5000
SET ROWCOUNT 0 --- 取消指定行數
-----------------------------------------------
UPDATE authors SET au_lname = 'Jones'
WHERE au_id = '999-888-7777'
IF @@ROWCOUNT = 0 --- 判斷是否有變化
begin
print 'Warning: No rows were updated'
end
GO
UPDATE titles
SET advance = 5000
WHERE advance >= 5000 -- 只能改變指定的4行
GO
SET ROWCOUNT 0
select * from titles WHERE advance >= 5000
SET ROWCOUNT 0 --- 取消指定行數
-----------------------------------------------
UPDATE authors SET au_lname = 'Jones'
WHERE au_id = '999-888-7777'
IF @@ROWCOUNT = 0 --- 判斷是否有變化
begin
print 'Warning: No rows were updated'
end