Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Meaning of identity

Author  Topic 

kneel
Starting Member

36 Posts

Posted - 2007-12-29 : 00:24:47
Hello All,

Does anyone knows what is the meaning of IDENTITY in following 2 rows.

[UserId] [bigint] IDENTITY (0, 1) NOT NULL ,
AND
[ProductId] [bigint] IDENTITY (1, 1) NOT NULL ,

Thanks in advance



--kneel

kiruthika
Yak Posting Veteran

67 Posts

Posted - 2007-12-29 : 00:54:01
Hi!

Identity means increment automatically.You dont need to insert value to the identity filed.

Identity(0,1)
0->seed(start)
1->increment

kiruthika!
http://www.ictned.eu
Go to Top of Page
   

- Advertisement -