Quickstart: Use the Azure portal query editor to query Azure SQL Database

Applies to: Azure SQL Database

The Azure SQL Database Query editor (preview) is a tool to run SQL queries against Azure SQL Database in the Azure portal. In this quickstart, you connect to an Azure SQL database in the Azure portal and use query editor to run Transact-SQL (T-SQL) queries.

Prerequisites

  • The AdventureWorksLT sample Azure SQL database. If you don't have it, you can create a database in Azure SQL Database that has the AdventureWorks sample data.

  • A user account with permissions to connect to the database and query editor. You can either:

    • Have or set up a user that can connect to the database with SQL authentication.
    • Have or set up a user that can connect to the database with Azure Active Directory (Azure AD) authentication.

Connect to the query editor

  1. On your SQL database Overview page in the Azure portal, select Query editor (preview) from the left menu.

    Screenshot that shows selecting query editor.

  2. On the sign-in screen, provide credentials to connect to the database. You can connect using SQL authentication or Azure AD.

    • To connect with SQL authentication, under SQL server authentication, enter a Login and Password for a user that has access to the database, and then select OK. You can always use the login and password for the server admin.

      Screenshot showing sign-in with SQL authentication.

    • To connect using Azure AD, if you're the Azure AD server admin, select Continue as <your user or group ID>. If sign-in is unsuccessful, try refreshing the page.

Query the database

On the Query editor (preview) page, run the following example queries against your AdventureWorksLT sample database.

Run a SELECT query

  1. To query for the top 20 products in the database, paste the following SELECT query into the query editor:

     SELECT TOP 20 pc.Name as CategoryName, p.name as ProductName
     FROM SalesLT.ProductCategory pc
     JOIN SalesLT.Product p
     ON pc.productcategoryid = p.productcategoryid;
    
  2. Select Run, and then review the output in the Results pane.

    Screenshot showing query editor results for a SELECT query.

  3. Optionally, you can select Save query to save the query as an .sql file, or select Export data as to export the results as a .json, .csv, or .xml file.

Run an INSERT query

To add a new product to the SalesLT.Product table, run the following INSERT T-SQL statement.

  1. In the query editor, replace the previous query with the following query:

    INSERT INTO [SalesLT].[Product]
           ( [Name]
           , [ProductNumber]
           , [Color]
           , [ProductCategoryID]
           , [StandardCost]
           , [ListPrice]
           , [SellStartDate]
           )
    VALUES
           ('myNewProduct'
           ,123456789
           ,'NewColor'
           ,1
           ,100
           ,100
           ,GETDATE() );
    
  2. Select Run to add the new product. After the query runs, the Messages pane displays Query succeeded: Affected rows: 1.

Run an UPDATE query

Run the following UPDATE T-SQL statement to update the price of your new product.

  1. In the query editor, replace the previous query with the following query:

    UPDATE [SalesLT].[Product]
    SET [ListPrice] = 125
    WHERE Name = 'myNewProduct';
    
  2. Select Run to update the specified row in the Product table. The Messages pane displays Query succeeded: Affected rows: 1.

Run a DELETE query

Run the following DELETE T-SQL statement to remove your new product.

  1. In the query editor, replace the previous query with the following query:

    DELETE FROM [SalesLT].[Product]
    WHERE Name = 'myNewProduct';
    
  2. Select Run to delete the specified row in the Product table. The Messages pane displays Query succeeded: Affected rows: 1.

Next steps