BISQL # 34 :What is Identity IN SQL {Identity Part–I}
Hi Friends,
We often use Identity Column in SQL Server DB,Lets go through each and every aspect of Identity
Some Facts about Identity :
- The IDENTITY property makes generating unique values easy.
- IDENTITY is not data type.
- IDENTITY is a column property.
- IDENTITY make column unique throughout
- Oracle does not support Identity
Example for Identity
Ex: CREATE TABLE IdentityDemo(IdentityDemo_id smallint IDENTITY NOT NULL, IdentityDemo_name VARCHAR(50) NOT NULL)
In above example the system function @@IDENTITY contains the last identity value used by the connection.
Setup for Identity
If you are designing table in SSMS then its very easy to make identity column
Step 1- Select Column that you want to make as identity
Ex:Lets say I have audit table and I wan make AuditID as my identity column as shown below
Stpe 2:After Selecting AuditID move to column properties
Step 3 : Now search identity Tab
Step 4: Open this tab and make IS Identity fields as Yes as shown
Before
After making Yes
And don’t forget to click on save details of table
We will have some more aspect on Identity in upcoming post
For more interesting find on related topic on daily basis you can visit my link resource website :Link Resource # 11 August 1 – August 2 « Dactylonomy of Web Resource
Hope this helps !!
For more interesting information on SQL we can also look into similar topics such as
· BISQL # 35 : Deep dive into Identity Functions in SQL {Identity Part–II}
· BISQL # 36 : Queries to Understand more on Identity aspect {Identity Part–III}
· BISQL # 37 :Checking, Seeding and Reseeding of Identity {Identity Part–IV}
· BISQL # 38 : Introduction To Function – {SQL Server Function Part – I }
· BISQL # 39 : Details of Row set functions – {SQL Server Function Part – II}
Hope you will like this post on Identity IN SQL Part I.
If you really like reading my blog and understood at least few thing then please don’t forget to subscribe my blog.
If you want daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog : Link Resource Website
For More information related to BI World visit my Mentalist Blog
Link Resource Blog >> Daily Interesting links
SQL Server Mentalist >> SQL Learning Blog
Business Intelligence Mentalist >> BI World
Connect With me on
Copyright © 2011 – 2012 Vishal Pawar
-
August 3, 2011 at 8:56 amBISQL # 35 :Deep dive into Identity Functions in SQL {Identity Part–II} « SQL Server Mentalist
-
August 3, 2011 at 9:10 amBISQL # 36 :Queries to Understand more on Identity aspect in SQL {Identity Part–II} « SQL Server Mentalist
-
August 3, 2011 at 9:39 amBISQL # 37 :Checking, Seeding and Reseeding feature of Identity in SQL {Identity Part–IV} « SQL Server Mentalist