Hi. How I can do a query on datatype ntext (xml file) in "SQL Query Analyzer" when I need all data? When I get select from this table, I get back
only first 256 bytes (chars)??? Thanks
Printable View
Hi. How I can do a query on datatype ntext (xml file) in "SQL Query Analyzer" when I need all data? When I get select from this table, I get back
only first 256 bytes (chars)??? Thanks
click on TOOLS- OPTIONS- Results tab -
change Maximum character per column to 8000
Great! How easy!! :) :) Thanks