PHWinfo - Afficher un message - delete output into <xml column of audit table>

31/03/2008, 16h34

You cannot do it in a single statement because the OUTPUT clause does not
support subqueries. One way is to get the deleted rows into a temp table and
then transfer as XML to your audit table.

Here is one example of implementing this in a trigger:
http://blogs.sqlservercentral.com/pr...-with-xml.aspx

HTH,

Plamen Ratchev
http://www.SQLStudio.com

31/03/2008, 16h34	#2
Plamen Ratchev Messages: n/a Hébergeur:	Re: delete output into <xml column of audit table> You cannot do it in a single statement because the OUTPUT clause does not support subqueries. One way is to get the deleted rows into a temp table and then transfer as XML to your audit table. Here is one example of implementing this in a trigger: http://blogs.sqlservercentral.com/pr...-with-xml.aspx HTH, Plamen Ratchev http://www.SQLStudio.com