VS 2010 IDE integration with SQL 2008 T-SQL Editor

Visual Studio 2010 has new feature to invoke T-SQL Editor inside its IDE itself.

So unlike in VS 2008 and other previous Visual Studio versions where you had to open SQL Server Management Studio to run the T-SQL queries, VS 2010 provides this feature which comes handly when you need to interact with database without leaving your Visusl Studio IDE.

You can access it through Data menu by choosing Transact-SQL Editor option. It offers connectivity only with SQL Server 2008 only, in order to open T-SQL Editor.


click on the image to see in larger view, use back button to continue reading

Once the T-SQL Editor is open it also shows the SQL related toolbar on the top, as shown marked in RED color on top-left, and allows you to work with SQL 2008 Databases without leaving the VS 2010 IDE.