(last updated: 2021-08-13 @ 19:50 ET / 2021-08-13 @ 23:50 UTC ) In a previous post, Prevent Full Script Execution (Understanding and Using PARSEONLY and NOEXEC), I explained how to easily disable a script using the PARSEONLY session setting. That same method can be used to disable one or more sections within a script instead… Continue reading SSMS and SQLCMD: Prevent T-SQL Batch From Not Only Executing, but Also From Parsing (Cruel Joke #3)
Tag: SSMS
SSMS: Prevent Copy and Paste of Text in “Messages” tab (Cruel Joke #2)
An invisible character is all it takes to have a little fun 🙃
SSMS Tip #3: Easily Access/Research ALL Unicode Characters (Yes, Including Emojis 😸)
Learn how to get a list of all Unicode characters to copy and paste, or use in queries / web pages / programs, or search by value, etc.
Line-Continuation in T-SQL
Some (or maybe most?) languages and operating system command shells allow for breaking up long lines into multiple lines (i.e. lines separated by hitting Enter / Return). This is accomplished by ending a line with a particular character that indicates that the line is not ending. For operating system shells this means that the command… Continue reading Line-Continuation in T-SQL
SSMS Tip #2: Shortcut Keys for SQLCMD Mode, Open Containing Folder, Copy Full Path, etc
In SQL Server Management Studio (SSMS), there are a lot of options and functions. In fact, there are so many that you might never see / encounter quite a few of them. Part of the issue is that there are four locations to find these options and functions. The four locations are: Menu bar (i.e.… Continue reading SSMS Tip #2: Shortcut Keys for SQLCMD Mode, Open Containing Folder, Copy Full Path, etc
SSMS Tip #1: Annotations and Map Mode for Vertical Scroll Bar
Check out the (only) completely complete guide to this cool feature of SSMS (that's off by default), including how to configure the colors 🎨 !