O'Reilly logo

Introducing SQL Server by Mike McQuillan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

APPENDIX C

image

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.

Global Variables

@@IDENTITY

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required