Automatically reformat SQL Keywords to UPPER CASE

19 May 2006 1:40 PM

SOG1

Is there a way to get SQL 2000 Query Analyzer or Visual Studio 2003 to
automatically re-format SQL keywords to upper case as you type?

I can do this in Ultra-Edit by editing an external file that contains all of
the keywords.

Thanks.

19 May 2006 3:37 PM

Jack Vamvas

Not uppercase specifically, you probably know this , but you can customise
keywords through the tools|options|fonts
For uppercase , check this:
http://www.aquafold.com/docs-qw-sqlformatter.html

--
----
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________

Show quote

"SOG1" <S***@discussions.microsoft.com> wrote in message
news:E3AB7C4C-7F22-4C42-9ABB-40D80AF5E820@microsoft.com...
> Is there a way to get SQL 2000 Query Analyzer or Visual Studio 2003 to
> automatically re-format SQL keywords to upper case as you type?
>
> I can do this in Ultra-Edit by editing an external file that contains all
of
> the keywords.
>
> Thanks.

19 May 2006 4:49 PM

Vern Rabe

I recently bought a license for PromptSQL, a tool that does just that along
with Intellisense, and works with several tools including Query Analyzer and
SQL Server Management Studio. A couple of weeks ago, Red Gate Software bought
the product, renamed to SQL Prompt, and is currently in beta for release 3.
I'm not sure what you can get right now, but you can try www.promptsql.com,
or Red Gates site, www.red-gate.com to see.

HTH
Vern

Show quote

"SOG1" wrote:

> Is there a way to get SQL 2000 Query Analyzer or Visual Studio 2003 to
> automatically re-format SQL keywords to upper case as you type?
>
> I can do this in Ultra-Edit by editing an external file that contains all of
> the keywords.
>
> Thanks.