22,209
社区成员
发帖
与我相关
我的任务
分享
CREATE TRIGGER tr_uTab ON dbo.table1
INSTEAD OF UPDATE
AS
SET NOCOUNT ON;
BEGIN
UPDATE t
SET Sex = i.Sex ,
opname = i.opname
--加上其它可更新列
FROM Inserted AS i
INNER JOIN table1 AS t ON i.ID = t.ID;
END
CREATE TRIGGER [dbo].[trg_UpdateB]
ON [dbo].[table1]
AFTER UPDATE
AS
BEGIN
SET NOCOUNT ON;
UPDATE t SET t. name =d. name ,t. name =d. name ,t. sex =d. sex ,t. birth_date =d. birth_date
FROM table1 AS t INNER JOIN DELETED d ON d.id=t.id
END