SQLServer and XML RAW
-
Does anyone knows how to extract the value of a query using FOR XML ?? All I want to do is assign the result value into a variable. Thanks :confused: Free your mind...
-
Does anyone knows how to extract the value of a query using FOR XML ?? All I want to do is assign the result value into a variable. Thanks :confused: Free your mind...
It basically comes out as a set of string fields. If using classic ADO, use a Recordset to capture it. If using ADO.NET, use a SqlDataReader.
-
It basically comes out as a set of string fields. If using classic ADO, use a Recordset to capture it. If using ADO.NET, use a SqlDataReader.
I know it works fine in the middle tier code. I just want to leave the result in the data tier (SQL Server). What I'm trying to do is a kind of audit trail, so when users update a record, I can take a snapshot of it (FOR XML RAW) and write it to another table. :) Free your mind...