CREATE TRIGGER uptest
ON 科系表
FOR uPDATE
as
declare @oldname varchar(20),@newname varchar(20)select @oldname = xiMingZi from deleted
select @newname = xiMingZi from inserted
update gongNeng set gongNengMingZi = replace (gongNengMingZi,@oldname,@newname)
go
------
后面的不明白楼主什么意思。
ON 科系表
FOR uPDATE
as
declare @oldname varchar(20),@newname varchar(20)select @oldname = xiMingZi from deleted
select @newname = xiMingZi from inserted
update gongNeng set gongNengMingZi = replace (gongNengMingZi,@oldname,@newname)
go
------
后面的不明白楼主什么意思。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货