触发器

CREATE TRIGGER [AA_delete] ON [dbo].[AA] FOR delete asbegindeclare @return_string varchar(255)SELECT @return_string=xtwpdm FROM DELETED --PRINT @return_stringupdate xtm12 SET wpsxlb36 =@return_string WHERE xtwpdm=@return_string --update a --set wpsxlb36 = d.xtwpdm --from xtm12 a , deleted d --where a.xtwpdm = d.xtwpdm END