实现你的目的,用以下代码
CREATE TRIGGER bakrecord on dbo.test FOR insert
as
UPDATE a SET province_bak=b.province,
city_bak=b.city
from dbo.test a,inserted b where a.username=b.username
这个在Oracle 中属于变异表..
在Oracle 中可以这么解决
create trigger tr_tr1 on tablename
as insert
set nocount on
update tablename set province_bak=province,city_bak=city
update of update of (province)省 city(市)
set nocount off
create trigger tr_tr1 on tablename
as insert
declare @province varchar(50),
@city varchar(50)
set nocount on
update tablename set province_bak=province,city_bak=city
set nocount off