create trigger k on t1 after insert as begin insert t2 (id) select id from inserted end
CREATE TRIGGER T ON T1 FOR INSERT AS BEGIN INSERT T2 (ID) SELECT ID FROM INSERTED END
create trigger T on t1 after insert as begin insert t2 (id) select id from inserted end
-- ========================================= -- -----------t_mac 小编------------------- --------------------希望有天成为大虾---- -- =========================================IF OBJECT_ID('t1') IS NOT NULL DROP TABLE t1 GO CREATE TABLE t1( id int, name varchar(10)) go IF OBJECT_ID('t2') IS NOT NULL DROP TABLE t2 GO CREATE TABLE t2( id int, gh varchar(10)) go create trigger k on t1 after insert as begin insert t2 (id) select id from inserted end insert t1 values(1,'a') select * from t2go id gh ----------- ---------- 1 NULL
create trigger t_1 on t1 for insert as if exists(select 1 from inserted) and not exists(select 1 from deleted) begin insert into t2(id) select id from inserted end
阿蒂 你说我那个有没有必要写?if exists(select 1 from inserted) and not exists(select 1 from deleted)
after insert
as
begin
insert t2 (id)
select id
from inserted
end
FOR INSERT
AS
BEGIN
INSERT T2 (ID) SELECT ID FROM INSERTED
END
after insert
as
begin
insert t2 (id)
select id from inserted
end
-- -----------t_mac 小编-------------------
--------------------希望有天成为大虾----
-- =========================================IF OBJECT_ID('t1') IS NOT NULL
DROP TABLE t1
GO
CREATE TABLE t1( id int, name varchar(10))
go
IF OBJECT_ID('t2') IS NOT NULL
DROP TABLE t2
GO
CREATE TABLE t2( id int, gh varchar(10))
go
create trigger k on t1
after insert
as
begin
insert t2 (id)
select id
from inserted
end
insert t1 values(1,'a')
select * from t2go
id gh
----------- ----------
1 NULL
create trigger t_1 on t1
for insert
as
if exists(select 1 from inserted) and not exists(select 1 from deleted)
begin
insert into t2(id) select id from inserted
end
你说我那个有没有必要写?if exists(select 1 from inserted) and not exists(select 1 from deleted)
如果楼主 需要 不插入重复ID 就要判断
但是INSERT触发器 不会用到DELETED表
CREATE TRIGGER T ON T1
FOR INSERT
AS
BEGIN
INSERT T2 (ID) SELECT ID FROM INSERTED
END