触发器代码入下:
CREATE trigger tri_updateAppraiserDw on dbo.AppraiserInfo
for update
as
begin
declare @str varchar(4000)
declare @strTitle varchar(50)
declare @OldDw varchar(100)
declare @NewDw varchar(100)
IF NOT UPDATE(DwID)
RETURN
set @str=''
set @strTitle='<br>'+convert(varchar(20),getdate(),120)+'修改了如下信息:'
if update(DwID)
select @OldDw=t.CompanyName from deleted d,DepartmentInfo t where t.iD=d.DwID
select @NewDw=t.CompanyName from inserted i ,DepartmentInfo t where t.iD=i.DwID
select @str=@str+'<br> 执业单位由'''+@OldDw+'''修改为'''+@NewDw+''';' from deleted d,inserted i where i.id=d.id and i.DwID<>d.DwID
if @str<>''update a set a.ZhiDanChange=convert(varchar(8000),isnull(a.ZhiDanChange,''))+' '+@strTitle+@str,a.ChangeDay=convert(varchar(20),getdate(),120) from AppraiserInfo a,deleted b where a.id=b.idend
CREATE trigger tri_updateAppraiserDw on dbo.AppraiserInfo
for update
as
begin
declare @str varchar(4000)
declare @strTitle varchar(50)
declare @OldDw varchar(100)
declare @NewDw varchar(100)
IF NOT UPDATE(DwID)
RETURN
set @str=''
set @strTitle='<br>'+convert(varchar(20),getdate(),120)+'修改了如下信息:'
if update(DwID)
select @OldDw=t.CompanyName from deleted d,DepartmentInfo t where t.iD=d.DwID
select @NewDw=t.CompanyName from inserted i ,DepartmentInfo t where t.iD=i.DwID
select @str=@str+'<br> 执业单位由'''+@OldDw+'''修改为'''+@NewDw+''';' from deleted d,inserted i where i.id=d.id and i.DwID<>d.DwID
if @str<>''update a set a.ZhiDanChange=convert(varchar(8000),isnull(a.ZhiDanChange,''))+' '+@strTitle+@str,a.ChangeDay=convert(varchar(20),getdate(),120) from AppraiserInfo a,deleted b where a.id=b.idend
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货