Have you ever needed to prevent an entire script (or part of one) from executing? See how the session-level options PARSEONLY and NOEXEC can accomplish this.
Tag: T-SQL
Native UTF-8 Support in SQL Server 2019: Savior or False Prophet?
An in-depth analysis of the new native UTF-8 support in SQL Server 2019.
Changing the Collation of the Instance, the Databases, and All Columns in All User Databases: What Could Possibly Go Wrong?
Need to change the collation at ALL levels? Prefer to avoid reloading all objects and data? Learn what the "sqlservr -q" option does, and doesn't, do.
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Identifiers, Part 3 of 2 (Delimited Identifiers)
The investigation into valid T-SQL identifier characters continues. Apparently I was not done.
Why Doesn’t CONTEXT_INFO() Return the Exact Value Set by SET CONTEXT_INFO?
If you have ever used SET CONTEXT_INFO to store a simple value, you probably ran into this frustrating behavior 🙀
What’s in a Name?: Inside the Wacky World of T-SQL Identifiers
Come see the complete set of rules governing how you name things in SQL Server
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 2
A captivating journey of twists and turns, searching for the mythical list of valid T-SQL identifier characters.
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 1
A captivating journey of twists and turns, searching for the mythical list of valid T-SQL identifier characters.
Safely and Easily Use High-Level Permissions Without Granting Them to Anyone: Database-level
Come see how easy it truly is to "grant" high-level permissions in the safest, most granular, most controllable way.
Safely and Easily Use High-Level Permissions Without Granting Them to Anyone: Server-level
Come see how easy it truly is to "grant" high-level permissions in the safest, most granular, most controllable way.