Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
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.
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: