-
Insert xml into table - problems!!
I'm trying to write a trigger that will store the inserted and deleted tables in a couple of varchars (in xml)
and then call something to insert into an audit table.
declare @temp table(v varchar(4000))
INSERT INTO @temp
SELECT *
FROM TblCust
FOR XML RAW
This doesn't work as I know you cant use FOR XML RAW
with an insert statement. Anyone have any ideas?
Thanks.
John
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|