Is there a option to change Keywords to uppercase

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Is there a option to change Keywords to uppercase

Author

Topic

savvy
Starting Member

48 Posts

Posted - 2007-12-10 : 06:44:03

I am always changing the Sql Query Keywords to UpperCase and formatting the T-sql.

Is there a option so that i can change the keywords to uppercase automatically in the sql 2005 management studio ?

How do most of you format the sql statements?

Please let me know it will save me and most of us like me alot of time.
Your help will be most appreciated.

Thanks in Advance

Savvy

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-12-10 : 07:04:38

I generally do not bother with uppercase as they are colour coded, but you can always use ctrl-shift + U to make them uppercase.

savvy
Starting Member

48 Posts

Posted - 2007-12-10 : 07:10:28

Thanks for your reply mate, umm., thats true, I am aware of this keyboard shortcut, but really wondering if there is an option to change it uppercase just after we finish typing the keyword, as we have to follow the coding standards its a must for us.

Savvy

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-12-10 : 07:12:36

See this discussion: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64597

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-10 : 07:13:13

There are several add-ins that take care of this.

E 12°55'05.25"
N 56°04'39.16"

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-12-10 : 07:13:30

AFAIK, Not without something like SQL Prompt.

savvy
Starting Member

48 Posts

Posted - 2007-12-10 : 07:28:49

Wow!! Thats a complete bundle example tools, I wanted.
Thats what I really wanted. Thank you very much guys for your help.
It does save us alot of time.
For my above keyboard formatting I have selected an option in SQL Prompt which converts the keyword to UpperCase as I finish typing, thats perfect.
And I'll dig into rest of them now.

Thank you very much guys once again.

Savvy

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources