34,590
社区成员
发帖
与我相关
我的任务
分享
CREATE TRIGGER TRIGGER1 ON table1
FOR INSERT
AS
declare @v_char
BEGIN
SET @v_char =(SELECT id FROM table1 inserted)
INSERT INTO table1_temp VALUES (@v_char, 1)
END
FOR DELETE
AS
declare @v_char
BEGIN
SET @v_char =(SELECT id FROM table1 deleted)
INSERT INTO table1_temp
VALUES (@v_char, 3)
END
FOR UPDATE
AS
declare @v_char
BEGIN
SET @v_char =(SELECT id FROM table1 inserted)
INSERT INTO table1_temp VALUES (@v_char, 3)
INSERT INTO table1_temp VALUES (@v_char, 1)
END
CREATE TRIGGER TRIGGER1 ON table1
FOR INSERT ,deleted,update
AS
BEGIN
INSERT INTO table1_temp select id, 1 from inserted
insert into table1_temp select id, 3 from deleted
END
go
CREATE TRIGGER TRIGGER1 ON table1
FOR INSERT
AS
BEGIN
INSERT INTO table1_temp select ID,1 from inserted
END
--這樣改