Afficher un message
Vieux 31/03/2008, 16h05   #1
cc
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut delete output into <xml column of audit table>

Currently running Sql Server 2005

Is it possible to issue the delete command and capture the affected rows as
xml types that will be stored in an audit table with an xml column?

Something along the lines of:

delete from source_table
output
(deleted.*
into audit_table (xml_audit_column)
for xml auto)
where source_table.column = @delete_value






  Réponse avec citation
 
Page generated in 0,04750 seconds with 9 queries