IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='trigger_delete'AND TYPE='TR')
DROP TRIGGER trigger_delete
GO
CREATE TRIGGER [trigger_delete]
ON dbo.TableA
after DELETE,insert,update
AS
BEGIN
INSERT INTO dbo.TB VALUES(4,'Keeking')
print 'inserted 表'
select * from inserted
print 'deleted 表'
select * from deleted
END
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7899089/viewspace-610537/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
