MSSQLTips

The really great news is that there is a new way to get the Identity value returned if you are using SQL Server 2005 . . . check out the OUT variables that you can use during an INSERT statement. You can return the ID column or anything else (even the whole bloody record ;-).