Large strings

Question

Post reply

Large strings

Steve Jones - SSC Editor

SSC Guru

Points: 736255
More actions
May 25, 2016 at 8:04 pm

#72583

Comments posted to this topic are about the item Large strings
May 25, 2016 at 11:43 pm

This was removed by the editor as SPAM

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Ed Wagner SSC Guru Points: 287026 More actions · Answer 1

Easy enough to help get the brain moving. Thanks.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

drew.allen SSC Guru Points: 76987 More actions · Answer 2

Well, the documentation for nchar and nvarchar still says that the the value can be any number from 1 to 4000 or max, and 5000 is clearly not in that range, so I was actually expecting an error, but that wasn't one of the choices.

Drew

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

Jacob Wilkins One Orange Chip Points: 27976 More actions · Answer 3

drew.allen (5/26/2016)
Well, the documentation for nchar and nvarchar still says that the the value can be any number from 1 to 4000 or max, and 5000 is clearly not in that range, so I was actually expecting an error, but that wasn't one of the choices.
Drew

How would that apply? Both variables are VARCHAR (or were when I looked at the question).

Cheers!

Luis Cazares SSC Guru Points: 183706 More actions · Answer 4

drew.allen (5/26/2016)
Well, the documentation for nchar and nvarchar still says that the the value can be any number from 1 to 4000 or max, and 5000 is clearly not in that range, so I was actually expecting an error, but that wasn't one of the choices.
Drew

Wrong data types. Here's the correct link: https://msdn.microsoft.com/en-us/library/ms176089.aspx

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

j-1064772 SSCertifiable Points: 5316 More actions · Answer 5

Got the answer but misread the question - did not notice the [font="Courier New"]varchar(MAX)[/font] vs [font="Courier New"]varchar(5000)[/font] !

Lesson repeated: when looking at T-SQL do not overlook details.

drew.allen SSC Guru Points: 76987 More actions · Answer 6

Jacob Wilkins (5/26/2016)
drew.allen (5/26/2016)
Well, the documentation for nchar and nvarchar still says that the the value can be any number from 1 to 4000 or max, and 5000 is clearly not in that range, so I was actually expecting an error, but that wasn't one of the choices.
Drew
How would that apply? Both variables are VARCHAR (or were when I looked at the question).
Cheers!

:blush: I guess my morning caffeine hadn't totally kicked in, yet. It's a good thing that producing an error wasn't one of the choices.

Drew

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

Jacob Wilkins One Orange Chip Points: 27976 More actions · Answer 7

I guess my morning caffeine hadn't totally kicked in...

Heh, been there more times than I'd care to admit 🙂

Anand BI Developer SSCommitted Points: 1772 More actions · Answer 8

DECLARE @a VARCHAR(max) = REPLICATE('a', 10);

DECLARE @b-2 VARCHAR(10) = REPLICATE('b', 10);

SELECT LEN(@a + @b-2);

Ans : 20