SQL Server - Identity
-
Hi There,
Can anyone tell me what is an Identity?
Thanks
-
Identity (or AutoNumber) is a column that automatically generates numeric values. A start and increment value can be set, but most DBAs leave these at 1. A GUID column also generates unique keys.
Nimol
Programmer
Corbin Creative Databases, LLC, http://www.corbincreative.com
-
Welcome to SSC!!
You can try to Google "IDENTITY SQL Server"
I am sure you will get lots of information which can't be provided in a single forum
If you still have any doubts after reading the articles, feel free to revert with questions.
Kingston DhasianHow to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/ -
corbincreativecomputing (7/26/2012)
Identity (or AutoNumber) is a column that automatically generates numeric values. A start and increment value can be set, but most DBAs leave these at 1. A GUID column also generates unique keys.Nimol
Programmer
Corbin Creative Databases, LLC, http://www.corbincreative.com
Just to add to, Identity can have negative values as well.
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
-
IDENTITY is a property which gives auto-incremental value to a column whenever a new record is inserted. You have to set the IDENTITY property with a column while creating a table.
Check following blog post to know about all IDENTITY columns: http://sqlwithmanoj.wordpress.com/2012/05/03/all-about-identity-columns/%5B/url%5D
You can also use IDENTITY() function with "SELECT INTO" statement.
Check following blog post for more info: http://sqlwithmanoj.wordpress.com/2011/12/15/using-identity-function-with-select-statement/%5B/url%5D
More link: http://sqlwithmanoj.wordpress.com/2011/07/08/reseed-tables-identity-column-value/%5B/url%5D
-
You can try to Google "IDENTITY SQL Server"
I am sure you will get lots of information which can't be provided in a single forum
If you still have any doubts after reading the articles, feel free to revert with questions.
You'll probably get an answer faster that way as well
I used to call my self The Master on forums, then I entered the IT industry and realised how much I still have to learn.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply