I've a SQL statement that returns a xml result, for a serialized object.I want to add a attribute to an element, that reflects the type of the object "xsi:type=table" but i don't know how?
-
Please post the query...Jon Seigel– Jon Seigel2010-11-15 02:19:05 +00:00Commented Nov 15, 2010 at 2:19
Add a comment
|
1 Answer
Could use some additional information on your problem, but here goes:
SELECT TOP 10 SomeId, COUNT(1) SomeValue
INTO #SomeTable
FROM (SELECT ABS(CAST(NEWID() AS binary(6)) % 1000) + 1 SomeId
FROM sysobjects) sample
GROUP BY SomeId;
WITH XMLNAMESPACES (N'http://www.w3.org/2001/XMLSchema-instance' as xsi)
SELECT SomeId "@SomeId",
-- here is where you specify the type to put in the attribute
'table' "@xsi:type",
SomeValue
FROM #SomeTable
FOR XML PATH('AnElement'), ROOT('RootElement')
DROP TABLE #SomeTable;