Integer lengths (I)

Question

Integer lengths (I)

TomThomson

SSC Guru

Points: 104773
More actions
June 29, 2015 at 9:31 pm

#299529

Comments posted to this topic are about the item Integer lengths (I)
Tom

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

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

sarah.ryan Valued Member Points: 71 More actions · Answer 1

Surely this question is less about integer lengths and more about string conversions?

What it's really drawing attention to is that str(), which produces a fixed length string, left pads on conversion, while cast/convert right pad a fixed length string. This happens regardless of whether the input is an integer.

Good question though - certainly highlighted something I was unaware of - glad I always opt for explicit type conversions

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 2

Great question, thanks!

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

palotaiarpad SSCertifiable Points: 5617 More actions · Answer 3

Nice,failed due to the right justified result of STR.

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

Well done, Tom. Not only way it clear, concise and correct, it made me think it through, which is always good. Thanks.

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

free_mascot One Orange Chip Points: 27164 More actions · Answer 5

Nice question, thanks Tom.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Ken SSCoach Points: 17191 More actions · Answer 6

Nice question Tom. I haven't used the STR() function before.

cgumprich Ten Centuries Points: 1069 More actions · Answer 7

cgumprich

Ten Centuries

Points: 1069

June 30, 2015 at 7:02 am

#1809102

Good one. Learned something by getting it wrong.

RLilj33 SSCrazy Points: 2203 More actions · Answer 8

Stewart "Arturius" Campbell (6/30/2015)
Nice question, thanks Tom
Never been fond of the STR() function myself, as i prefer explicit cast/convert

+1. My thoughts exactly.

webrunner SSC-Dedicated Points: 31984 More actions · Answer 9

Cool question, thanks.

- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Revenant SSC-Forever Points: 42467 More actions · Answer 10

Revenant

SSC-Forever

Points: 42467

June 30, 2015 at 11:56 am

#1809255

Very neat. Thanks you, Tom!

Umer Akram SSC-Insane Points: 22209 More actions · Answer 11

Umer Akram

SSC-Insane

Points: 22209

June 30, 2015 at 11:37 pm

#1809367

great question. thanks for sharing

Arno Kwetters Hall of Fame Points: 3876 More actions · Answer 12

Is NULL=NULL true ?

That's the question.

Most things in life can be reduced to one single question.

Hany Helmy SSChampion Points: 13921 More actions · Answer 13

Stewart "Arturius" Campbell (7/1/2015)
ArnoKwetters (7/1/2015)
Is NULL=NULL true ?
NULL != NULL or anything else.
NULL is actually a reflection of the state of the field, i.e. there is no value assigned to it.
This is where playing aound with SET ANSI_NULL delivers some interesting results...

Thank u!

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

TomThomson SSC Guru Points: 104773 More actions · Answer 14

Stewart "Arturius" Campbell (7/1/2015)

ArnoKwetters (7/1/2015)
Is NULL=NULL true ?

NULL != NULL or anything else.

NULL is actually a reflection of the state of the field, i.e. there is no value assigned to it.

This is where playing aound with SET ANSI_NULL delivers some interesting results...

[/quote

Yes, my question and answer assume ANSI_NULL is set on; that is the default situation for sQL Server, and the ability to set it off has been deprecate for a very long time and will soon be unavailable. Any comparison involving NULL (either as both arguments or as one f them) delivers UNKNOWN - not TRUE, and not FALSE.

Tom

Integer lengths (I)

Cookies on SQLServerCentral