开发者

Capitalise SQL Server 2008 keywords

开发者 https://www.devze.com 2023-03-03 06:41 出处:网络
I want to capitalise all the letters that are SQL keywords. For example, if I write this: Select * From EmpMast

I want to capitalise all the letters that are SQL keywords. For example, if I write this:

Select *
From EmpMast

I want it to become:

开发者_开发百科
SELECT *
FROM Empmast

How should I do that?


If you are typing this code into the Query editor window, this task would be performed by a third-party tool. Personally, I would suggest one of the tools from RedGate software. It is called SQL Prompt. It helps you write your SQL queries. It is an invaluable tool. Here is a link to it:

http://www.red-gate.com/products/sql-development/sql-prompt/

0

精彩评论

暂无评论...
验证码 换一张
取 消