Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.
Create TRIGGER [dbo].[tri_pfAudit_@tblName_INSERT] ON [dbo].[@tblName] AFTER INSERT AS Declare @x as XML --In select I need to check if text, and convert to varchar Select @x = (Select * from Inserted FOR XML AUTO, BINARY BASE64 , ELEMENTS, Root(''ROOT'')) Insert Table_Audit(TableName,txtXML,Action) Select ''@tblName'',@x,''I''
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.