Database Reference
In-Depth Information
Figure 6.50
Log on to SQL database server through web browser.
Database anytime and anywhere, this hands-on activity will be carried out in Windows
Azure SQL Database. he following illustrates how to connect to the Windows Azure SQL
Database server and query the tables in the database Class_Registration:
1. On your local computer, log on to Windows Azure through the URL
https:// yourserver .database.windows.net
where yourserver is your SQL Database server name. Enter the database name Class_
Registration . hen, enter your user name and password to log on to Windows Azure
SQL Database as shown in Figure 6.50. Once you have logged on, click the New
Query icon at the upper-left corner of your screen.
2. Example 1: To select the information about the buildings, you can use the following
SELECT statement:
SELECT * FROM BUILDING
Click the Run icon to execute the query. he result is shown in Figure 6.51.
3. Example 2: In the next exercise, you will select the students whose last names begin
with a letter between D and T. Enter the below query.
SELECT FirstName, LastName
FROM STUDENT
WHERE LastName Like '[D-T]%'
Highlight the code and click Run . he result is shown in Figure 6.52.
Search WWH ::




Custom Search