Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 varchar(400)

Author  Topic 

sardinka
Posting Yak Master

142 Posts

Posted - 2005-08-18 : 08:07:22
I have a field varchar(400) when I run a query in query anal. it is not displaying all text. What should I do in order to display all data?

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-08-18 : 08:15:44
In the Query Analyser
Goto Tools->Options->Results
and increase Maximum characters per column to 400

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

sardinka
Posting Yak Master

142 Posts

Posted - 2005-08-18 : 10:08:15
Thank you. What about when I am transfering the data to Excel using DTS. it is also loosing the data.
Go to Top of Page
   

- Advertisement -