If you write code to SQL Server then you might be interested in this: I have written a tSQLt tdd training course which has helped over 500 people learn both tSQLt and how to apply TDD practices to their SQL Server T-SQL development, you can join the course at https://courses.agilesql.club.

Changing case of T-SQL Keywords

Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5…

Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes some internal struggle as it is actually one person “Mr Bert Ernie” anyway I digress, whether you are working by yourself or in a team you sometimes want to change the case of all the keywords in some code.

If you are using SSDT you can use my new SSDT-DevPack tool to do it for you:

If you grab the devpac, any T-SQL keywords in the active document will be made UPPERCASE when you do “tools->SSDT Dev Pack–>Upper Case Keywords” and I will leave it up to your imagination as to what happens when you do “tools->SSDT Dev Pack–>Lower Case Keywords”.

As always, you can map these to keyboard shortcuts, I use Ctrl+K,L for lowercase and ctrl+k,u for UPPERCASE.

Any problems please shout, grab the installer from:

https://github.com/GoEddie/SSDT-DevPack/blob/master/release/SSDTDevPack….

Enjoy :)


Comments:

Anonymous

December 10, 2015 - 14:01

It works great.

It works great.

Ed Elliott

December 10, 2015 - 14:06

Great :)

Great :)

Subscribe

* indicates required

Please select all the ways you would like to hear from Agile Sql Club:

You can unsubscribe at any time by clicking the link in the footer of our emails. For information about our privacy practices, please visit our website.

We use Mailchimp as our marketing platform. By clicking below to subscribe, you acknowledge that your information will be transferred to Mailchimp for processing. Learn more about Mailchimp's privacy practices here.