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.
| Author |
Topic |
|
pmanneni
Starting Member
1 Post |
 Posted - 2010-07-31 : 09:13:23
|
| I have a record of more than 4 MB in a table. When I give a Select query on the table for a column I'm able to see only partial value of that column. For example :The column x has a value of xxxaaavvvggghhhtttuuuiiiOOOOPPPPPBut when I give select x from table ..... I'm getting partial data xxxaaavvvggghhhtttHow to see the whole column value ?Thanks in advance |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-07-31 : 10:13:35
|
| In management studio. Tools-> Options. Go to Query results and change the maximum characters displayed settings.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
How to get the whole column value in a table