How to read long text in sql server

Sometime you might want to read the entire text in a particular table column. If you execute the command

select longColumn from MyTable

You will see that you can only read the first 50 characters are so. If you are doing this in SQL Server Management studio, simply right click on the column or cell and select copy. Then past is word or any text editor of your choice. It quite easy but can some give you trouble.

Leave a Reply

Your email address will not be published. Required fields are marked *