SQL Statement Formatter

From: John Viele (john.noVieleSpam_at_hummingbird.com)
Date: 01/13/05 

Date: Thu, 13 Jan 2005 10:48:41 -0500

I'm looking for a software component (Active-X control, .NET library, DLL,
whatever) that will take a SQL statement and reformat it to make it
readable. I want to customize the way it reformats.

I deal with some big hairy ugly SQL statements that are dynamically
generated and it's a royal pain to manually reformat them for analysis every
time. I tried using REGEX to write my own reformatter, but I don't think it
can do what I want (or at least it would be easier to write my own parser
code than to get REGEX to do this).

If anyone knows of a great utility for this, please let me know. Thanks.

Relevant Pages

  • Re: SQL Statement Formatter
    ... > whatever) that will take a SQL statement and reformat it to make it ... > generated and it's a royal pain to manually reformat them for analysis every ... I tried using REGEX to write my own reformatter, ... the web if you have access to a web search engine. ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL Statement Formatter
    ... >whatever) that will take a SQL statement and reformat it to make it ... I want to customize the way it reformats. ... >generated and it's a royal pain to manually reformat them for analysis every ... I tried using REGEX to write my own reformatter, ...
    (microsoft.public.sqlserver.programming)
  • query problem
    ... This is how I would like to reformat the table. ... thinking it can be run as a SQL statement maybe? ... Mark ... Prev by Date: ...
    (microsoft.public.access.queries)
Loading