create trigger tr_name on tablename for insert as if exists(select 1 from inserted where eqname like '%PC机%' or eqname like '%服务器%') insert into PC(字段列表) values('','',''...)
create trigger t_insert on eg for insert as if exists(select 1 from inserted where egname in('PC机','服务器')) insert into pc表(字段) values(null) go
我尝试了zjcxc(邹建)的语句可以实现。 现在我希望插入的不是一条空记录, insert into pc(num) values(eq表中num字段的值) 可我发现不能insert into pc(num) values(num)写 请问要如何更改,谢谢啦!
可以 :create trigger t_insert on eg for insert as if exists(select 1 from inserted where egname in('PC机','服务器')) insert into pc表(字段) values(null) go
create trigger tr_name on tablename for insert as if exists(select 1 from inserted where eqname like '%PC机%' or eqname like '%服务器%') insert into PC(字段列表) values('','',''...)
for insert
as
if exists(select 1 from inserted where eqname like '%PC机%' or eqname like '%服务器%')
insert into PC(字段列表) values('','',''...)
for insert
as
if exists(select 1 from inserted where egname in('PC机','服务器'))
insert into pc表(字段) values(null)
go
现在我希望插入的不是一条空记录,
insert into pc(num) values(eq表中num字段的值)
可我发现不能insert into pc(num) values(num)写
请问要如何更改,谢谢啦!
for insert
as
if exists(select 1 from inserted where egname in('PC机','服务器'))
insert into pc表(字段) values(null)
go
for insert
as
if exists(select 1 from inserted where eqname like '%PC机%' or eqname like '%服务器%')
insert into PC(字段列表) values('','',''...)