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
 CAPITAL LETTERS

Author  Topic 

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-09-06 : 15:21:09
Any option on sql server to have the reserved words converted into CAPITAL when I type it in. Like "SELECT"

=============================
http://www.sqlserverstudy.com

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2007-09-06 : 15:22:29
for what purpose?

--------------------
keeping it simple...
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2007-09-06 : 15:24:15
Google for SQL Beautifier
Go to Top of Page

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-09-06 : 15:27:06
quote:
Originally posted by jen

for what purpose?

--------------------
keeping it simple...



It sounds like a cool idea to me, would be a great enhancement to SSMS.



Future guru in the making.
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2007-09-06 : 15:33:10
keywords are highlighted, that is enough for me

capital letters intimidate me... i guess if the scripter is color blind upper case would be great

--------------------
keeping it simple...
Go to Top of Page

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2007-09-06 : 15:36:55
The short answer is no. But, there are some third party stuff that might help. One add-in that comes to mind is SQL Prompt by Red gate. Also, there is a free program/website that will do some formatting for you at: [url]www.sqlinform.com[/url]
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2007-09-06 : 15:50:29
<rant>

as a dba and/or developer, there are more important stuff than making your code beautiful like 'right' logic (not just any logic will do it has to be correct) and documentation?

and posting it in this forum (new to sql server) may mean the poster is a beginner or plans to create a similar tool? If latter, my apologies for the rant.

but that's me

</rant>



--------------------
keeping it simple...
Go to Top of Page

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-09-06 : 18:06:12
quote:
Originally posted by jen

keywords are highlighted, that is enough for me

capital letters intimidate me... i guess if the scripter is color blind upper case would be great

--------------------
keeping it simple...



DON'T BE AFRAID!



Future guru in the making.
Go to Top of Page

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2007-09-07 : 17:20:07
quote:
Originally posted by jen

for what purpose?

--------------------
keeping it simple...



Beautiful answer

rockmoose
Go to Top of Page
   

- Advertisement -