Enterprise Manager / SSMS – Convert selection to Uppercase/Lowercase

I don’t know why I have this habit, but typically I write most of my queries in lowercase. All lowercase. Once I’m ready to publish them or have them reviewed, I’ll convert everything applicable (some parameters don’t need to be made uppercase) to uppercase.

CTRL+SHIFT+U converts your text selection to uppercase. CTRL+SHIFT+L converts your text selection to lowercase.

SQL Server – F5 Executes Query

After you’ve parsed your query, in SQL Server, just press F5 and the query will be executed.

SQL Server – CTRL+F5 Parses Query

Instead of going up to the check mark to parse your query for syntactic goodness, just press CTRL+F5.