27,579
社区成员
发帖
与我相关
我的任务
分享
IF OBJECT_ID('TA') IS NOT NULL
DROP TABLE ta
GO
CREATE TABLE TA(ID INT IDENTITY(1,1) PRIMARY KEY, C1 INT, C2 INT, C3 INT)
GO
INSERT INTO TA VALUES(NULL, 10, 1)
INSERT INTO TA VALUES(30, NULL, 2)
INSERT INTO TA VALUES(20, 20, 3)
GO
SELECT * FROM TA
GO
IF OBJECT_ID('TRI_TA') IS NOT NULL
DROP TRIGGER TRI_TA
GO
CREATE TRIGGER TRI_TA
ON TA
INSTEAD OF UPDATE
AS
UPDATE TA
SET C1 = A.C1 , C2 = A.C2
FROM TA
JOIN inserted A
ON TA.ID = A.ID
GO
UPDATE TA
SET C1 = 23, C2 = 32, C3 = 99
where ID = 2
SELECT * FROM TA