Underground And Other Stuff

SQL Server provides the variable @@Identity to solve a particular problem that you may encounter when writing stored procedures. However, the @@Identity value has no concept of scope. Learn how you can work around this issue by using the new Scope_Identity() function.

http://ct.techrepublic.com.com/clicks?c=243518-993479&brand=techrepublic&ds=5