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 |
|
sqlps
Starting Member
8 Posts |
 Posted - 2013-10-26 : 22:35:56
|
| I have table with a column having nvarchar(max) type.datastored in that column having more than 1.5 lakh character width.But while i select this column using simple select query it could notshow the string stored in that column . only shows string with width lesser than actual. but i checked the length of the data stored in thecolumn ,it shows correct length. please help me if there any method toselect entire string |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-10-27 : 00:11:23
|
| This is a limitation of SSMS. You can change how many characters are displayed by Query -> Query Options and then Grid tab or Text tab as the case may be and setting the max number of characters to be displayed. But there is a max limit to what you can set it to. 65535 for grid and a lower number of text. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-27 : 02:28:05
|
| i usually dump contents onto a file and then check value inside it.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
sqlps
Starting Member
8 Posts |
Posted - 2013-10-27 : 13:10:21
|
| Thank you, James ,Vishakh.cpuld you please explain how to dump the result into file |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-10-27 : 13:22:49
|
quote:
Originally posted by sqlps
Thank you, James ,Vishakh.cpuld you please explain how to dump the result into file
In SSMS select Query -> Results To -> Results To File and then run the query. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-27 : 14:32:33
|
quote:
Originally posted by sqlps
Thank you, James ,Vishakh.cpuld you please explain how to dump the result into file
simply select results to file optionor alternatively use Export Import wizard------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
SSMS issue