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/default.asp?url=/library/en-us/vdtsql/dvrefsqlpane.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" <[email protected]>
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: <#CavQ#[email protected]>
Newsgroups: microsoft.public.dotnet.languages.vb
NNTP-Posting-Host: 210.176.185.16
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.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/default.asp?url=/library/en-us/vdtsql/dvrefsqlpane.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