代碼 CREATE?TRIGGER?[dbo].[Up_T]
ON?[dbo].[T1]
FOR?UPDATE?
AS
begin
????if?update(T1_1)
????BEGIN
????????--用游標，一個一個處理
????????DECLARE?@fID?int
????????DECLARE?tmpGoods?CURSOR?for?select?ID?from?deleted
????????OPEN?tmpGoods
????????FETCH?NEXT?FROM?tmpGoods?into?@fID
????????WHILE?@@FETCH_STATUS=0
????????BEGIN
????????????--操作語句
????????????update?T1?set?T1_2='32h4'?where?ID=@fID
????????FETCH?NEXT?FROM?tmpGoods?into?@fID
????????END
????????CLOSE?tmpGoods
????????DEALLOCATE?tmpGoods
????END
END

轉載于:https://www.cnblogs.com/hantianwei/archive/2009/11/27/1612284.html

總結

以上是生活随笔為你收集整理的触发器批量更新 用游标，一个一个处理的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。