Sunday, March 25, 2012

Calling SQL editor dialog from application

The SQL (or query) editor in Visual Studio is a great tool. Is there a way to call the editor from my application to edit a SQL string?

This is not for the end user but as a developer tool for those who have a copy of Visual Studio. I would like to be able to visually design the SQL commands we are storing in a database.

Thanks, Dave C.

Hi Dave,
There is no direct way to launch the SQL Query editor based on a string in your application. The best you can do is save the string to a file and then use the command line parameters for loading that file into SSMS using SQLWB.EXE.
Thank you,
Bill Ramos, PM, SSMS

No comments:

Post a Comment