Getting the size in bytes of an XML Field

  • Hello!

    I was just wondering if it possible to get the size of an XML field stored in sql via a TSQL query?

  • Well thanks a lot for all your responses!

    I thought that this would have been quite straight forward.. (and it is, as you can see)

    The way to do this is:

    DATALENGTH(XML FIELD)

     

    Im rather surprised that no one knew this!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply