create trigger charu on cc for insert as declare @dept_id int declare @dpart_id int declare @name varchar(10) select @dept_id=dept_id from inserted select @dpart_id=dpart_id from inserted select @name=name from inserted insert aa select @dept_id,null,null insert bb select @dpart_id,@name go 为什么同步insert的时候不这样
insert into bb (a,b) values (@dpart_id,@name)
他的语法跟一般的SQL有什么不同吗?
go
insert into bb (a,b) select @dpart_id,@name
insert aa select dept_id,null,null from inserted
insert bb select dpart_id,name from inserted