SQL Management Studio in Visual Studio 2010

Posted By jalpesh On 06 Aug 2011 21:08:58

Tag : Visual Studios

Digg del.icio.us Newsvine Facebook Google MySpace Reddit Twitter Windows Live YahooBuzz FriendFeed

No of Views	:	1551
Bookmarked	:	0 times
Votes	:	0 times

Introduction

Microsoft Visual Studio 2010 is a great IDE and everyday I am discovering something new about it. Today I am also going to explain new feature of Visual Studio 2010. In this post I am going to Transact SQL Editor feature in Visual Studio 2010.

Visual Studio 2010 Ultimate Edition provides this great feature. You can run you SQL Queries in visual studio 2010 itself with all intellisense and all the stuff that SQL Server provides. Let’s explore in details.

To connect the database of your SQL Server in Visual studio Go to Data->Transact SQL Editor –>New Query connection like following.

Now once you click it will open the dialog box for connection SQL server like it. If you don’t have install anything it will install SQL Server 2008 express edition with Visual Studio 2010 Ultimate Edition. The dialog appear like following.

Once you are done with the connection it will open full fledge Query editor windows with intellisesnse like following.

Also it can connect to any databases including your SQL Azure databases also. Isn’t that great. You don’t need SQL management studio at all for the basic database operations. That’s it. Hope you like it.


Other popular Tips/Tricks
Browser selection in Visual Studio 2012 This article will be a part of Visual Studio 2012 features series. As now Visual Studio 2011 beta know as Visual Studio 2012. Published Date : 21/Nov/2012 Image preview in solution explorer Visual Studio 2012 This article will be part of Visual Studio 2012 feature series. As Visual Studio 2011 beta is known as Visual Studio 2012. Published Date : 21/Nov/2012 The Box Selection in Visual Studio 2010 In this tips, I'm going to explain how to do box selection in visual studio 2010. Published Date : 06/Aug/2011 Multi Monitor Support in Visual Studio 2010 In this tip we are going to see an new feature for multi monitor support in Visual Studio 2010. In Visual Studio 2010 you can drag windows outside IDE and thus you can use in different monitor Published Date : 22/Jan/2011 How to debug process with visual studio 2005/2008 And aspnet_wp.exe Some time while you are testing you need to debug some things in your asp.net application Published Date : 11/Jun/2010

Comments

There is no comments for this articles.