概述IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE XTYPE = 'TR' AND NAME = 'insertajfkdate') DROP TRIGGER insertajfkdate GO CREATE TRIGGER insertajfkdate ON s_getin FOR INSERT AS --提交事务处理 BEGIN TRANSACTION IF EXISTS (SELECT name FROM SYSOBJECTS WHERE XTYPE = 'TR' AND name = 'insertajfkdate') DROP TRIGGER insertajfkdate GO CREATE TRIGGER insertajfkdate ON s_getin FOR INSERT AS --提交事务处理 BEGIN TRANSACTION --强制执行下列语句,保证业务规则 UPDATE s_room SET s_room.ajfkdate=t.[getdate] From (select [getdate] from s_getin) as t Where s_room.roomno=t.[getdate] COMMIT TRANSACTION GO 总结
以上是内存溢出为你收集整理的sqlserver 触发器全部内容,希望文章能够帮你解决sqlserver 触发器所遇到的程序开发问题。
如果觉得内存溢出网站内容还不错,欢迎将内存溢出网站推荐给程序员好友。
评论列表(0条)