22,209
社区成员
发帖
与我相关
我的任务
分享
go
if object_id('tri_tracy')is not null
drop trigger tri_tracy
go
create trigger tri_tracy on A
for insert
as
if exists(select 1 from inserted)
and not exists(select 1 from deleted)
begin
insert B
select a,b,cast(ceiling(rand()*100000) as int),getdate() from inserted
end