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

Posted by Sabarimahesh under Sql Server on 3/22/2012 | Points: 10 | Views : 2058 | 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

[Resolved]

Reply | Reply with Attachment

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

0	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

0	Hi Refer to: http://blog.sqlauthority.com/2007/03/25/sql-server-identity-vs-scope_identity-vs-ident_current-retrieve-last-inserted-identity-of-record/ Thanks, Sanjay Sabarimahesh, if this helps please login to Mark As Answer. \| Alert Moderator

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

0	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

0	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

0	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

0	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

0	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

0	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

0	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

0	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

0	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

0	@@Identity automaticaly to increase the value. Regards sriram Sabarimahesh, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts