Sql Server : Keyboard shortcut to change to UPPER CASE in Sql Server Management Studio (SSMS)
- Posted by Sqltimes
- On April 29, 2015
- 0 Comments
Quick one today:
As alwways, there is value in formatting SQL code in a proper way. There are several ‘proper’ ways to format code; And all are great. To each, their own.
But one formatting tip that everyone appreciates is keeping Sql Server identifiers or keywords in UPPER CASE.
There is a keyboard shortcut, that allows this operation : Ctrl + Shift + U
|
1
2
3
4
5
6
7
8
9
|
---- Some random un-formatted code.--beginset nocount ondeclare @starttime datetimedeclare @hierarchyid intdeclare @nodeid bigintdeclare @statuscode int |
Highlight the word that you want to change to UPPER CASE and use the keyboard short cut: Ctrl + Shift + U. Similarly, changing to lower case could be accomplished with Ctrl + Shift + L
|
1
2
3
4
5
6
7
8
9
10
|
---- After formatting--BEGINSET NOCOUNT ONDECLARE @starttime DATETIMEDECLARE @hierarchyid INTDECLARE @nodeid BIGINTDECLARE @statuscode INT |
Hope this helps,
_Sqltimes
0 Comments