Querying using Azure SQL Database
Step 1: Go to the Azure SQL database resource that was deployed.
Step 2: In the pane on the left side of the page, select the Query editor and then sign in using the administrator login and password we had specified for our server.
Note: If you receive an error message stating that the client IP address isn’t allowed, select the Allow list IP link at the end of the message to allow access and try to sign in again.
Step 3: Expand the Tables folder to see the tables in the database.
Step 4: In the Query 1 pane that appears, enter the following SQL code:
SELECT * FROM [SalesLT].[SalesOrderHeader]
Step 5: Select the Run option above the query to run it and view the results, which will include all the columns for all rows in the table as shown below:
Step 6: This way we can run all our SQL queries. Close the query editor pane which will discard our edits.
This is how we can create Azure SQL database resources and use them in our cloud applications.
Microsoft Azure SQL Database | Complete Tutorial
Azure SQL Database is a relational database (RDBMS) service provided by Microsoft Azure that is widely used by developers when creating new applications in the cloud. It is managed completely by Microsoft and is a highly scalable platform-as-a-service (PaaS) designed especially for cloud applications. Here, we create a managed database server in the cloud and use the server to deploy our database. The server is a logical construct that acts as the central administration point for pooled databases or multiple logins, auditing rules, threat detection policy, and failover groups.
Table of Content
- Microsoft Azure SQL Database
- What is Microsoft Azure SQL Database?
- Azure SQL vs. SQL Server
- Why Azure SQL Database?
- SQL Azure Architecture
- Azure SQL Database Features
- Azure SQL Database Tiers
- Azure SQL Database Services
- Microsoft Azure SQL Database Hands-on
- Querying using Azure SQL Database
- Pricing Of Azure SQL Database
- Deleting Databases in AzureSQL
- Conclusion
- Azure SQL Database – FAQs
Contact Us