By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,856 Members | 2,179 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,856 IT Pros & Developers. It's quick & easy.

Query Analyzer. Align/indent stored procedure script

P: n/a
Hi,

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

Thanks, Eugene
Jul 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Eugene (yg********@hotmail.com) writes:
Is there a way to align/indent the stored procedure script ( like VBA
Add-Ins Smart Indenter )


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, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2

P: 3
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
Sep 14 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.