有没有通用触发器?【200分!】
来源:百度知道 编辑:UC知道 时间:2024/09/20 12:04:03
MSSQL
因为不知道有没有,不敢乱悬赏浪费分。能给出来立即加200分!
你不懂吗?
--insert 触发器
CREATE TRIGGER [INSERT_FOR_a1] ON [a1]
FOR INSERT
AS
INSERT INTO b服务器LinkServer的名字.数据库名.dbo.a1(1,2,3,4,5)
SELECT [1],[2],[3],[4],[5] FROM INSERTED
GO
--update 触发器
CREATE TRIGGER [UPDATE_FOR_a1] ON [a1]
FOR UPDATE
AS
DELETE FROM b服务器LinkServer的名字.数据库名.dbo.a1
WHERE [主键字段] IN (SELECT [主键] FROM DELETED)
INSERT INTO b服务器LinkServer的名字.数据库名.dbo.a1(1,2,3,4,5)
SELECT [1],[2],[3],[4],[5] FROM INSERTED
GO
--delete 触发器
CREATE TRIGGER [DELETE_FOR_a1] ON [a1]
FOR DELETE
AS
DELETE FROM b服务器LinkServer的名字.数据库名.dbo.a1
WHERE [主键字段] IN (SELECT [主键] FROM DELETED)
GO
Insert不能通用,靠自己
200分,哪呢,,
题上赫然写着一个大字
“0分”