byteMyCode: Snippet Revisions http://www.bytemycode.com Revisions for this snippet. Fri, 21 Nov 2008 06:43:05 +0000 1998-2008 en-us http://www.bytemycode.com http://www.bytemycode.com/img/rss_title.gif byteMyCode MSSQL Return Identity after Insert 1 http://www.bytemycode.com/snippets/snippet/417/1/ http://www.bytemycode.com/snippets/snippet/417/comments/ Thu, 05 Oct 2006 20:48:31 +0000 Thomas MSSQL http://www.bytemycode.com/snippets/snippet/417/ Often when inserting information in a database we need to know the value of the autonumber/identity field so that we can insert related data in another table. MSSQL Server provides a SCOPE_IDENTITY() function for just such a purpose (PHP/MySQL users have the mysql_insert_id() function -- lucky).

*This is in the generic section because there is no MSSQL Server or Database section.

]]>