How To: Read Text Field <LongText> data completely from SQL Query Analyzer

In Microsoft SQL Server, Text field column's data/content cannot be read completely, if the length of the data exceeds certain amount. Even through Enterprise Manager, you can see only as '<Long Text>' . So how to view the entire content. Here's a trick for you.

DECLARE @data VarChar(5000)
SELECT @data = TextFieldColumnName FROM MyTableName WHERE Condition='something'
Print @data

These 3 lines of code, will print the entire content of Text field column completely.

Post New Tips/Tricks

View all Tips/Tricks

Featured Resources:

Introduction to Web Applications Development

This 376 page eBook "Introduction to Web Applications Development", starts with an introduction to the internet, including a brief history of the TCT/IP protocol and World Wide Web.

The ASP.NET 2.0 Anthology: 101 Essential Tips, Tricks & Hacks - Free 156 Page Preview

Learn the most practical features and best approaches for ASP.NET.

100% Free Subscription until Stock lost.View complete list.