Chapter 22. Undocumented Transact-SQL

To a great designer, not applying knowledge is tantamount to not having obtained the knowledge in the first place.

Steve McConnell[1]

[1] McConnell, Steve. After the Gold Rush. Redmond, WA:Microsoft Press, 1999. Page 27.

You're better off not using undocumented features unless there's just no other way. Undocumented features are usually undocumented for good reason: They may be unsafe to use in certain circumstances, or they may change or be removed in future releases. Misuse of a product's undocumented features is a fast ticket to lost data and indifference from the vendor.

So be careful with the undocumented stored procedures, commands, functions, and syntax I'm about to share with you. Use them at your ...

Get Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, The now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.