Calling MS SQL's Query Designer to reformat SQL Statement?

[Norton]

Hi all ,

i would like to make a small utility which allow me to reformat the sql
statement from clipboard. I am finding ways which allow me to make use of MS
SQL's Query Designer.

http://msdn.microsoft.com/library/de...refsqlpane.asp

Do u know if there any way to achieve that? Any other alternative is
welcomed.
Thx in advance!

Regards,
Norton

[Cameron Slade [MSFT]]

Hi Norton,

I am not sure what your expectations are in regards to what Microsoft might have available. My take is that you would like to have access to a ActiveX Control or Framework class that will do
SQL formating. Microsoft doesn't provide a public class or interface that does SQL statement formatting.
--------------------

From: "Norton" <no********@hotmail.com>
Subject: Calling MS SQL's Query Designer to reformat SQL Statement?
Date: Thu, 30 Sep 2004 09:48:18 +0800
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
Message-ID: <#C**************@tk2msftngp13.phx.gbl>
Newsgroups: microsoft.public.dotnet.languages.vb
NNTP-Posting-Host: 210.176.185.16
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFT NGP08.phx.gbl!tk2msftngp13.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.languages.vb:232076
X-Tomcat-NG: microsoft.public.dotnet.languages.vb

Hi all ,

i would like to make a small utility which allow me to reformat the sql
statement from clipboard. I am finding ways which allow me to make use of MS
SQL's Query Designer.

http://msdn.microsoft.com/library/de...refsqlpane.asp

Do u know if there any way to achieve that? Any other alternative is
welcomed.
Thx in advance!

Regards,
Norton

Cameron Slade
Microsoft VSData Team
http://blogs.msdn.com/vsdata
--

This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.