create trigger my_trigger on AA
for update
as
declare @id int
select @id = id from deleted
update AB
set name=namegd,
xb= xbgd
where id = @iddeclare @namegd nchar(10)
declare @xb nchar(10)select @namegd =namegd from inserted where id = @id
select @xb =xb from inserted where id = @idupdate AB
set namegd = @namegd,
xb=@xb
where id = @id
for update
as
declare @id int
select @id = id from deleted
update AB
set name=namegd,
xb= xbgd
where id = @iddeclare @namegd nchar(10)
declare @xb nchar(10)select @namegd =namegd from inserted where id = @id
select @xb =xb from inserted where id = @idupdate AB
set namegd = @namegd,
xb=@xb
where id = @id
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货