PRINT vagaries

Question

Post reply

PRINT vagaries

Ol'SureHand

SSCrazy

Points: 2744
More actions
June 29, 2010 at 9:45 pm

#223348

Comments posted to this topic are about the item PRINT vagaries

Viewing 15 posts - 1 through 15 (of 49 total)

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

UMG Developer SSChampion Points: 13482 More actions · Answer 1

UMG Developer

SSChampion

Points: 13482

June 29, 2010 at 9:53 pm

#1186838

Nice question thanks!

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 2

Good tricky one...thank you

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

udayroy15 Ten Centuries Points: 1076 More actions · Answer 3

udayroy15

Ten Centuries

Points: 1076

June 30, 2010 at 12:06 am

#1186860

Interesting & tricky!!

Kari Suresh Hall of Fame Points: 3712 More actions · Answer 4

[p]Yes.. it is tricky, this query also results the same..[/p]PRINT LEN(@StringArray) + '-' + LEN(@Delimiter)

KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

Atif-ullah Sheikh SSChampion Points: 12495 More actions · Answer 5

Good question..

And its because the datatype of the variables ( @lenStringArray and @lenDelimiter) is INT.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.
You can check my BLOG [font="Arial Black"]here[/font][/url][/right]

dgvozdetsky SSCrazy Points: 2464 More actions · Answer 6

dgvozdetsky

SSCrazy

Points: 2464

June 30, 2010 at 12:35 am

#1186866

Good question!!! Thanks!:-)

Christian Buettner-167247 SSChampion Points: 13729 More actions · Answer 7

Nice question, but this is not a "PRINT vagary". Instead this is just how type conversion works (http://msdn.microsoft.com/en-us/library/ms190309.aspx).

SELECT @lenStringArray + '-' + @lenDelimiter

behaves the same way, because int (@lenStringArray & @lenDelimiter) has a higher precedence than varchar(1) ('_').

Best Regards,

Chris Büttner

dbuendiab SSC Eights! Points: 993 More actions · Answer 8

I'm surprised but is true:

Select Cast( '+' as int ) --> 0

Select Cast( '-' as int ) --> 0

info 25880 SSC Enthusiast Points: 177 More actions · Answer 9

Yes, that's reason, because the result of an implicit casting of '-' is zero

SELECT 6 + 1 + '-'

hrvoje.piasevoli Ten Centuries Points: 1377 More actions · Answer 10

Good tricky one...thank you

It would be even trickier if the first answer was 5.

Hrvoje

Hrvoje Piasevoli

cengland0 SSCertifiable Points: 6102 More actions · Answer 11

info 25880 (6/30/2010)
Yes, that's reason, because the result of an implicit casting of '-' is zero
SELECT 6 + 1 + '-'

So if you substitute the '-' with something clearly a string like 'a', you get a conversion failed message.

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 12

Good question. The only thing I dislike about it is the description "PRINT vagaries" because, as others have noted, the PRINT statement is completely innocent.

A better name would have been "Implicit type casting vagaries".

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

TonyThorne Right there with Babe Points: 749 More actions · Answer 13

Nice question. At first glance my answer would have been 5, but as this was not an option, I had to review the question.

I think more people would have been caught out if 5 had been an answer.

prashant.bhatt SSC-Addicted Points: 476 More actions · Answer 14

Excellent question and great to know the deal

Prashant Bhatt
Sr Engineer - Application Programming