//復制優(yōu)惠券表解鉤 Use HSHDBNew SELECT * INTO TempExistCoupon FROM DiscountActivityPager WHERE 1=2

--update觸發(fā)器 Create TRIGGER tri_update?? ON? DiscountActivityPager???????? ? AFTER update? as begin? if update(UDSateID) and (select top 1 UDSateID? from DiscountActivityPager WHERE UDID=(select top 1 UDID from Deleted))='2' INSERT INTO [TempExistCoupon] (UDID,UserID,BID,DID,UDNO,UDCode,UDDateTime,Memorandum,DiscontDetail,BusName,UDSateID,CheckDate,CheckIntegralCount,Ratings,StarLevel,CheckContentStr,BEID,UserCount,BatNo) SELECT [UDID],[UserID],[BID],[DID],[UDNO],[UDCode],[UDDateTime],[Memorandum],[DiscontDetail],[BusName],[UDSateID],[CheckDate],[CheckIntegralCount],[Ratings],[StarLevel],[CheckContentStr],[BEID],[UserCount],[BatNo] FROM DiscountActivityPager? where UDID=(select top 1 UDID from Deleted) end

總結

以上是生活随笔為你收集整理的更新数据库触发器的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。