CREATE TRIGGER insert_table1
ON table1 FOR INSERT
AS
UPDATE table1 SET 字段1='y' from inserted where id = inserted.id
ON table1 FOR INSERT
AS
UPDATE table1 SET 字段1='y' from inserted where id = inserted.id
调试欢乐多
INSTEAD OF INSERT
AS
BEGIN
INSERT INTO 表 (字段1,字段2,字段3) SELECT 'y',字段2,字段3 FROM inserted
END
CREATE TRIGGER insert_table1
ON table1 FOR INSERT
AS
UPDATE table1 SET 字段1='y' from inserted where id = inserted.id