Query Analyzer. Align/indent stored procedure script

[Eugene]

Hi,

Is there a way to align/indent the stored procedure script ( like VBA
Add-Ins Smart Indenter )

Thanks, Eugene

[Erland Sommarskog]

Re: Query Analyzer. Align/indent stored procedure script

Eugene (ygorelik20@hot mail.com) writes:[color=blue]
> Is there a way to align/indent the stored procedure script ( like VBA
> Add-Ins Smart Indenter )[/color]

You can select a couple of lines and indent with tab, or undent with
shift-tab. But I have never seen any hanging indent.

I use QA for ad-hoc queries only.

When writing actual code, I use Textpad, http://www.textpad.com. There
is no particular SQL support, but it's an overall better editor. (Syntax
colouring for SQL is possible.)


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[guidomarcel]

Hi,
maybe you can try the free online SQL Formatter called SQLinForm at http://www.sqlinform.com . You can use the version 1 with most computers as this Java applet is working with the very early versionof Java Runtime Environment 1.1 . The applet allows to format SQL statements independently from the DB used and you can format SQL code out of program code and / or format it for many different languages.

Hope this helps
Guido