Microsoft SQL (MSSQL): Display Field's Values Only Showing Maximal 256 Characters

You use Microsoft SQL 2000 Query Analyzer and you already insert some values with more than 256 Character into your table. But when you display the field's values, it only show 256 character length, and the rest of the values is gone.

Don't worry, your table still have the original values, but you must change the MS SQL 2000 Query Analyzer settings, so it can display more than 256 characters.

Just do these following:
1. Open MS SQL 2000 Query Analyzer
2. At Tools Menu, choose Option
3. Select the "Results" tab
4. Change "Maximum characters per column" to something else

Article Source: Monx Digital Library

Copyrighted@ Monx Digital Library, otherwise stated
Use of our service is protected by our Terms of Use

Back To Previous Page ...