• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 827
  • Last Modified:

xml field size

How can one get the xml's data size ?
I know it can be up to 2GB, but what is the real net size of a concrete variable (of field) ?

I'd like to get something like:

select lenght(xml_data_field) from my_xml_table

Thanks
0
gregajesih
Asked:
gregajesih
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
use DATALENGTH()
0
 
gregajesihAuthor Commented:
Indeeed. Thanks. Very very veeery fast!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now