mysql_insert_id() equivalent in ms sql

[sfullman]

If anyone knows; is there any equivalent in mssql to mysql_insert_id()?

Obviously a yes would be a very good answer at this point.

Sam Fullman
Compass Point Media

[tomhath]

SQL Server leaves the value in a global variable called @@IDENTITY.

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q170/1/47.asp&NoWebContent=1

http://www.drdev.net/article08.htm