Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Convert query letters to uppercase using Management Studio

Tags:

ssms

Can I convert query syntax to uppercase using SQL Server Management Studio? I have a bunch of queries that are all written in lowercase letters, and I want to convert them all to uppercase letters. I'm looking for a built-in editor functionality.

like image 654
Mark13426 Avatar asked Oct 22 '12 19:10

Mark13426


1 Answers

Select all of your query. Then go to Edit > Advanced > Make Uppercase or simply hit Ctrl+Shift+U to make the query uppercase.
Please note that it will make everything uppercase. (i.e., table names, fields name, strings etc.)

EDIT:
If you are able to install add-ins, you can also use SSMS Tools Packs to uppercase only the keywords.

like image 151
Mohammad Banisaeid Avatar answered Oct 02 '22 14:10

Mohammad Banisaeid