What is Purposeof using @@Identity?????? [Resolved]

Posted by Sabarimahesh under Sql Server on 3/22/2012 | Points: 10 | Views : 865 | Status : [Member] | Replies : 12
Wat Is the use?????

How it is use?????

Where it use?????

Life is a Race
Thanks & Regards
By
Sabari Mahesh P M



Responses

Posted by: Sksamantaray on: 3/24/2012 [Member] Silver | Points: 50

Up
0
Down

Resolved
Hi Sabari Mahesh,
I have found another small yet informative link for you.
http://www.dotnetfunda.com/articles/article516-difference-between-scopeidentity-and-identity.aspx
If helps mark as answer.

Thanks,
Sanjay

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sksamantaray on: 3/22/2012 [Member] Silver | Points: 25
Posted by: Sabarimahesh on: 3/23/2012 [Member] Bronze | Points: 25

Up
0
Down
Sksamantaray

OK Thank MAn ...

Anything Different purpose usage...

Life is a Race
Thanks & Regards
By
Sabari Mahesh P M

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Patel28rajendra on: 3/23/2012 [Member] Starter | Points: 25

Up
0
Down
Hi

@@Identity is built in Function of T-sql
After execution of an INSERT, SELECT INTO, or bulk copy statement is completed
@@IDENTITY contains the last identity value that is generated by the statement.

R D Patel

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Patel28rajendra on: 3/24/2012 [Member] Starter | Points: 25

Up
0
Down
Hi

refer this link

http://msdn.microsoft.com/en-us/library/aa933167%28v=sql.80%29.aspx

R D Patel

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Patel28rajendra on: 3/24/2012 [Member] Starter | Points: 25

Up
0
Down
Hi

this is also nice link

http://www.blackwasp.co.uk/SQLScopeIdentity.aspx

R D Patel

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sksamantaray on: 3/24/2012 [Member] Silver | Points: 25

Up
0
Down
Hi Sabari Mahesh,
I have another informative link for you for more examples.
http://programming4.us/database/1968.aspx
If it helps you mark as answer.

Thanks,
Sanjay

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sabarimahesh on: 3/26/2012 [Member] Bronze | Points: 25

Up
0
Down
HI Sksamantaray
Thanks To all


Life is a Race
Thanks & Regards
By
Sabari Mahesh P M

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Patel28rajendra on: 3/26/2012 [Member] Starter | Points: 25

Up
0
Down
Hi

Sabari Mahesh

you are Welcome

R D Patel

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sksamantaray on: 3/26/2012 [Member] Silver | Points: 25

Up
0
Down
Thank Sabari Mahesh.

Thanks,
Sanjay

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sabarimahesh on: 3/27/2012 [Member] Bronze | Points: 25

Up
0
Down
Sksamantaray
Welcome Man

Life is a Race
Thanks & Regards
By
Sabari Mahesh P M

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sriramnandha on: 5/20/2012 [Member] Starter | Points: 25

Up
0
Down
@@Identity automaticaly to increase the value.


Regards


sriram

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response