Identity Data Types

Question

Identity Data Types

Steve Jones - SSC Editor

SSC Guru

Points: 736183
More actions
January 12, 2015 at 11:05 pm

#100901

Comments posted to this topic are about the item Identity Data Types
January 13, 2015 at 1:04 am

This was removed by the editor as SPAM

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

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

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 1

Thank for the post, Steve, interesting one.

(Well, the score is exact 50-50 at this moment; the most common data type for identity column is INT, I am sure or trying to stay positive, that 50% of people who answered it wrong selected the choice by practice, even though they knew it, its just a practice haphazard. I was going to be one of them as I use it commonly, but vaguely I knew that it can take others too as a valid type, so I selected the answer and I did not submit and went and created 6 tables 😀 to be sure. Creation part was success and my doubts crept in possibly it might throw error at the inserting time.... and then I inserted record in each table... YES!!! no issues at all. Finally my first selected choice as correct... and it was time to click "submit".) 😛

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

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

Easy one, thanks.

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

AndrewJ_uk SSC Journeyman Points: 98 More actions · Answer 3

Howdy Steve.

Tut. I got it wrong. I usually get them wrong 🙂 In two of the options, you list the type numeric(p.0).

It was shown as p.0 (pee, full-stop, zero). Does that work? I thought it should be pee, comma, zero.

Cheers AJ

rhythmk SSCertifiable Points: 7271 More actions · Answer 4

Thanks Steve for question.Though I got it wrong just because of usual practice of keeping it as int 🙂

--rhythmk
------------------------------------------------------------------
To post your question use below link

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂

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

I usually use it for integer or bigint columns, but this caused me to have to think about it and play. Hence, I learned something new this morning, so thank you.

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

Sean Lange SSC Guru Points: 286590 More actions · Answer 6

Good question. I knew the answer and managed to select the wrong answer...no more QOTD before the first cup of coffee. 😉

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Dana Medley SSCertifiable Points: 6764 More actions · Answer 7

Ed Wagner (1/13/2015)
I usually use it for integer or bigint columns, but this caused me to have to think about it and play. Hence, I learned something new this morning, so thank you.

+1 Thanks for the question

Everything is awesome!

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

Sean Lange (1/13/2015)
Good question. I knew the answer and managed to select the wrong answer...no more QOTD before the first cup of coffee. 😉

d'oh, I hate it when that happens.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

Dana Medley (1/13/2015)

Fantastic!

Get that bug!:hehe:

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Marcia J SSCertifiable Points: 5649 More actions · Answer 10

SQLRNNR (1/13/2015)
Dana Medley (1/13/2015)
Fantastic!
Get that bug!:hehe:

Love it.

julienchappel 38298 SSC Eights! Points: 838 More actions · Answer 11

Hi Steve this question of IDENTITY column data type your answer is wrong. The correct answer is quoted from http://msdn.microsoft.com/en-AU/library/ms189838.aspx:

IDENTITY (Function) (Transact-SQL) data type

Valid data types for an identity column are any data types of the integer data type category, except for the bit data type, or decimal data type. According to your "correct" answer decimal and numeric can be Identity type as well. Not by Microsoft.

Kind regards

Julien DB Analyst/DBA

TomThomson SSC Guru Points: 104773 More actions · Answer 12

julienchappel 38298 (1/13/2015)
Hi Steve this question of IDENTITY column data type your answer is wrong. The correct answer is quoted from http://msdn.microsoft.com/en-AU/library/ms189838.aspx:
IDENTITY (Function) (Transact-SQL) data type
Valid data types for an identity column are any data types of the integer data type category, except for the bit data type, or decimal data type. According to your "correct" answer decimal and numeric can be Identity type as well. Not by Microsoft.
Kind regards
Julien DB Analyst/DBA

integer types (except bit) or decimal is what your quotation says, so Steve was not wrong to include decimal.

since numeric is actually another name for decimal he's not wrong to include that either.

So what are you complaining about?

Tom

TomThomson SSC Guru Points: 104773 More actions · Answer 13

Nice question. Pity about the typing error, though ("." for ",").

Tom