String in Query - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

String in Query

Author

Topic

naveengopinathasari
Yak Posting Veteran

60 Posts

Posted - 2011-09-22 : 06:13:14

Hi

Select

'Line 11111111111111111111111111111111111111111111111111111111111111111111' + CHAR(10) +
'Line 222222222222222222222222222222222222222222222222222222222222222222222' + CHAR(10) +
'Line 222222222222222222222222222222222222222222222222222222222222222222222' + CHAR(10) +
'Line 444444444444444444444444444444444444444444444444444444444444446666666' + CHAR(10) +
'Line 55555555555555555555555555555555555555555'

This query is not returning all the values
also this have to displayed in 5 lines and not in a line.

Please suggest

Lets unLearn

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-09-22 : 06:49:26

that is just the limitation of the query window. It does not display all the text of a column.

On SSMS, click on Query Option and under "Result - Text" change the "Max number of characters displayed in each column" to accommodate your string

KH
[spoiler]Time is always against us[/spoiler]

naveengopinathasari
Yak Posting Veteran

60 Posts

Posted - 2011-09-22 : 08:22:45

Thanks KH.

Its working fine.

Lets unLearn

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources