Determine length of SQL Server 2005 XML Data returned -


is there way predermine length of returned xml data sql server.

ex:

select * products xml raw, root('products') 

i using sql server 2005.

select datalength (                     (select *                     products                     xml raw, root('products')                     )                  ) 

it give size in bytes. details, see here: http://msdn.microsoft.com/en-us/library/ms173486(v=sql.90).aspx


Comments

Popular posts from this blog

javascript - Iterate over array and calculate average values of array-parts -

iphone - Using nested NSDictionary with Picker -

objective c - Newbie question -multiple parameters -