Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

2. SQL Azure Services > Working with SQL Azure from SQL Server Management Studi...

Working with SQL Azure from SQL Server Management Studio

When you are connected to the SQL Azure Server from SSMS, you can work with the server objects as you would with local servers except that SQL Azure supports (presently) only a subset of the features supported by SQL Server 2008 R2 (November CTP). We will now review a number of features that are supported fully or partially.

Creating queries

Querying databases is one of the important tasks that you would do on a regular basis and the process of querying SQL Azure is no different from querying other databases except for some changes in the commands, as follows:

  1. Click on Connect | Database Engine... toolbar item in SSMS to open the Connect to Server dialog.
  2. Enter the credentials as before and click the Connect button.

  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint