可以的,不过好象要如下:
create trigger test
on table1
for update
as
update table2 set field1=(select field1 from inserted) where
field1=(select field1 from deleted)
不过好象要用游标写比较正确。
create trigger test
on table1
for update
as
declare @newfield1 varchar(10),@oldfield1 varchar(10)
declare cur_test1 cursor
for
select field1 from deleted
open cur_test1
fetch next from cur_test1
into oldfield1
declare cur_test cursor
for
select field1 from inserted
open cur_test
fetch next from cur_test
into @newfield1
while @@fetch_status
begin
update table2 set field1=@newfield1 where field1 = @oldfield1
fetch next from cur_test1
into @oldfield1
fetch next from cur_test
into @newField1
end
create trigger test
on table1
for update
as
update table2 set field1=(select field1 from inserted) where
field1=(select field1 from deleted)
不过好象要用游标写比较正确。
create trigger test
on table1
for update
as
declare @newfield1 varchar(10),@oldfield1 varchar(10)
declare cur_test1 cursor
for
select field1 from deleted
open cur_test1
fetch next from cur_test1
into oldfield1
declare cur_test cursor
for
select field1 from inserted
open cur_test
fetch next from cur_test
into @newfield1
while @@fetch_status
begin
update table2 set field1=@newfield1 where field1 = @oldfield1
fetch next from cur_test1
into @oldfield1
fetch next from cur_test
into @newField1
end
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货