34,590
社区成员
发帖
与我相关
我的任务
分享
go
create table tb(id int ,name_ch varchar(100))
go
create trigger inserttrigger_s on tb
for insert
as
begin
select * from inserted
end
go
create trigger deltrigger_s on tb
for delete
as
begin
select * from deleted
end
insert into tb
select 1, 'a' union all
select 1, 'a' union all
select 1, 'a'
delete from tb
---结果
id name_ch
----------- ----------------------------------------------------------------------------------------------------
1 a
1 a
1 a
(3 row(s) affected)
(3 row(s) affected)
id name_ch
----------- ----------------------------------------------------------------------------------------------------
1 a
1 a
1 a
(3 row(s) affected)
(3 row(s) affected)