Geeks With Blogs
Phil Sando

This handy bit of sql code returns the last identity value inserted into an identity column in the current scope and sets its value to the parameter @ID

SET @ID = SCOPE_IDENTITY()

I found this a very useful thing to get to grips with and start using in my code. For further information on scope identity hit this msdn link

 

Posted on Wednesday, February 10, 2010 11:14 AM | Back to top


Comments on this post: Scope Identity (short but sweet)

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © PhilSando | Powered by: GeeksWithBlogs.net