THE ADVANCED TAB IN QUERY ANALYZER 2K

The new Query Analyzer tool that comes with SQL Server 2000 is full of
new and interesting functionality. One new functionality is the 
Advanced
Tab. You can get to this tab from the Edit | Advanced drop-down menu at
the top of the menu bar.

This tab allows you to perform the following functions:


1. Make selections upper or lower case.

2. Increase or decrease indents.

3. Comment out or remove comment syntax.

Like many Windows commands, the functions are not active until you
highlight or select text for these functions to act upon.

You can select/highlight a block of text or code, and the block of text
will be changed according to the function you choose.

For example:


* Select *from authors becomes SELECT * FROM AUTHORS with upper case
conversion.

* Select *from authors becomes Select * from authors with increase
indent.

* Select *from authors becomes - select *from authors with comment out
functionality.

These new aspects of Query Analyzer may seem quite simple at first
glance, but their use will be invaluable to the transact SQL coder.

There is one note regarding the indent functionality. It seems that you
must select more than one line of text or at least have a carriage 
return
line feed at the end of the first line in order for this to work
properly.

----------------------------------------