在SQL SERVER 有insered 和UPDATED for example:create tirgger utr_test on table2 name insered of insert as begin insert into table1 select * from insered end go
1.oracle中有:new和:old. sqlserver咋作? 用inserted和deleted 2. create tirgger name on a for insert as declare @id int select @id=id from inserted update a set id1=@id where id=@id go
触发器中 a表上的after insert 里边
用update a表语句不行啊
for example:create tirgger utr_test on table2 name
insered of insert
as
begin
insert into table1 select * from insered
end
go
sqlserver咋作?
用inserted和deleted
2.
create tirgger name on a
for insert
as
declare @id int
select @id=id from inserted
update a set id1=@id where id=@id
go