Professional Visual Studio® 2008

57.8. T-SQL Editor

This editor allows you to work with T-SQL code directly in Visual Studio. To open it, you can double-click a .sql file in Solution Explorer or from the Schema View of a Database Project. Another option is to start with a blank editor—to do this go to Data T-SQL Editor and select New Query Connection. Now you can start to write your T-SQL, with nice coloring and having most of Visual Studio's shortcuts and features like bookmarks and search and replace. From the Toolbar or the T-SQL Editor menu, you can validate syntax, execute your code, include client statistics, disconnect to work offline, and reconnect once you need to run a query. When you run the queries, the results can be displayed on a grid or text format or be exported to a file. You can also change this behavior from the menu or Toolbar.