Home Forums SQL Server 2008 T-SQL (SS2K8) How can use "Select " Get the XML result RE: How can use "Select " Get the XML result

  • April 24, 2014 at 12:27 am

    #1708317

    redcn2004 (4/24/2014)

    I want to Print all the records to a XML Page,So I Need to convert select result to variable

    there is a limitation on Print statement that your value should not be greater then 8000 bytes.

    so if you have a small record like Eirikur Eiriksson example, then its okay. but when you remove where clause and try to print the it data will be truncated.