Re: SQL Statement Formatter

From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 01/14/05 

Date: Fri, 14 Jan 2005 10:39:33 +0100

On Thu, 13 Jan 2005 10:48:41 -0500, John Viele wrote:

>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.
>

Hi John,

Here's a free SQL web-based formatter, with (limited) options to control
how the output looks:

http://www.sqlinform.com/

Best, Hugo 

-- 
(Remove _NO_ and _SPAM_ to get my e-mail address)

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)
  • SQL Statement Formatter
    ... 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 ... 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)