Auto-formatting of sql in Query Analyzer?

• edmund-235385

  SSC Enthusiast

  Points: 165

  More actions

  March 1, 2006 at 2:33 pm

  #167780

  Hi all,

  I have a lot of lengthy queries which are autogenerated, and therefore not nicely formatted, which makes debugging a pain.

  Is there a way I can paste in an unformatted query and have Query Analyzer "pretty print" it for me?

  Is there a better tool for the job?

  Thanks for any tips!

• Craig M. Rosenblum

  SSC Enthusiast

  Points: 164

  More actions

  March 2, 2006 at 7:29 am

  #624300

  Which is one of many reasons why I use AQT at http://www.querytool.com

  What i like is that you can configure exactly how you want it to re-write your queries, save it as your default configuration...

  Then everytime you build new queries they will be made in your format and style.

• Jeff Moden

  SSC Guru

  Points: 1004591

  More actions

  March 5, 2006 at 9:19 pm

  #624803

  What do I lookup to figure out how to change how the formatting is done?  All I could find was the following and it wasn't very helpful...

  Format SQL

  You can format an SQL statement by clicking on Edit > Format SQL. This will reformat your SQL in a layout which is more easily read.

  • all comments will be removed from your SQL. In the future we hope to leave comments intact.
  • only select, create view and insert statements will be formatted. Other statements will not be changed (except for the removal of comments).
  • you can have up to 1000 statements in your SQL - each will be formatted in turn and delimited with a semicolon.
  • if you have selected some text, only the selected text will be formatted.

  Insert statements will be formatted in a way which makes it easy to match the insert-value with the column being inserted; if the insert statement has a column list, the column name will be given (preceded by the comment indicator --) to the right if the column value. This syntax may not be valid for many databases, for which the comment indicator can only be given at the start of a line. However such insert statements will run OK within AQT.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)