Monday, March 26, 2012

How to make KEYWORD uppercase?

How to make KEYWORD uppercase in Management Studio?
Thanks.
--FrankFrank Lee (Reply@.to.newsgroup) writes:
> How to make KEYWORD uppercase in Management Studio?
You hold the shift key pressed down, then the you press the k, e, y, w,
o, r and d keys in that order.
Seriously, there is no intellisense or other code-formatting capabilities
in Mgmt Studio. You get colour-coding, but that's it.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||highlight it and click ctrl-shift-U
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Frank Lee" <Reply@.to.newsgroup> wrote in message
news:eGOB$$CYGHA.4248@.TK2MSFTNGP05.phx.gbl...
> How to make KEYWORD uppercase in Management Studio?
> Thanks.
> --Frank
>|||"Erland Sommarskog" <esquel@.sommarskog.se>
'?:Xns97A6826CC9DC7Yazorman@.127.0.0.1...
> Frank Lee (Reply@.to.newsgroup) writes:
> You hold the shift key pressed down, then the you press the k, e, y, w,
> o, r and d keys in that order.
: )|||"Hilary Cotter" <hilary.cotter@.gmail.com> glsD:umId0%23HYGHA.4684@.TK2MSFTNGP03.ph
x.gbl...
> highlight it and click ctrl-shift-U
>
:) Sorry, I didn't say clearly. I mean how to make ALL KEYWORDS in a sql
file uppercase.
Anyway, I have written a tool to do it.
Thanks.
--Frank.

No comments:

Post a Comment