Common SQL Server System Objects
SQL Server contains numerous system objects that greatly enhance the T-SQL language and your productivity. There are too many to mention here, but some of the more commonly used objects are briefly outlined, along with most of the functions/procedures we’ve seen throughout this book.
Returns the last identity column inserted into the database. This value can come from any insert that occurred in any table from any user. Because of this you cannot guarantee the value returned to you is the value you caused to be inserted. For this reason, the SCOPE_IDENTITY() function is a ...