October 18, 2017 at 9:22 pm
Comments posted to this topic are about the item sp_helptext
October 18, 2017 at 11:28 pm
Good question thanks Steve.
...
October 19, 2017 at 8:09 am
Isn't this limited by the setting on the options dialog - [maximum number of characters displayed in each column]? (It allows 8192)
October 19, 2017 at 8:36 am
sqlaz - Thursday, October 19, 2017 8:09 AMIsn't this limited by the setting on the options dialog - [maximum number of characters displayed in each column]? (It allows 8192)
no, it still returns 255 per row. it shifts the text down to the next line so be careful!
I did a little article about this a while back.
http://www.sqlservercentral.com/articles/T-SQL/161941/
There are some interesting quirks to say the least!
October 19, 2017 at 9:23 am
allinadazework - Thursday, October 19, 2017 8:36 AMsqlaz - Thursday, October 19, 2017 8:09 AMIsn't this limited by the setting on the options dialog - [maximum number of characters displayed in each column]? (It allows 8192)no, it still returns 255 per row. it shifts the text down to the next line so be careful!
I did a little article about this a while back.
http://www.sqlservercentral.com/articles/T-SQL/161941/
There are some interesting quirks to say the least!
Got it! Thought it was a shortcoming on the SSMS/VS editor part - but even when scripted out through powershell or programmatically, it does wrap at 255 characters. You'd be lucky to get a formatting error, and really have to be unlucky to mess up and not get an error. Very good observation, and nice article!
October 20, 2017 at 3:21 am
allinadazework - Thursday, October 19, 2017 8:36 AMsqlaz - Thursday, October 19, 2017 8:09 AMIsn't this limited by the setting on the options dialog - [maximum number of characters displayed in each column]? (It allows 8192)no, it still returns 255 per row. it shifts the text down to the next line so be careful!
I did a little article about this a while back.
http://www.sqlservercentral.com/articles/T-SQL/161941/
There are some interesting quirks to say the least!
Nice question, thanks Steve
and thanks for the additional reference, Andy
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply