Quickstart: Connect and query SQL Server using SQL Operations Studio (preview)

This quickstart shows how to use SQL Operations Studio (preview) to connect to SQL Server, and then use Transact-SQL (T-SQL) statements to create the TutorialDB used in SQL Operations Studio (preview) tutorials.

Prerequisites

To complete this quickstart, you need SQL Operations Studio (preview), and access to a SQL Server.

If you don't have access to a SQL Server, select your platform from the following links (make sure you remember your SQL Login and Password!):

Connect to a SQL Server

  1. Start SQL Operations Studio (preview).
  2. The first time you run SQL Operations Studio (preview) the Connection dialog opens. If the Connection dialog doesn't open, click the New Connection icon in the SERVERS page:

    New Connection Icon

  3. This article uses SQL Login, but Windows Authentication is supported. Fill in the fields as follows:

    • Server Name: localhost
    • Authentication Type: SQL Login
    • User name: User name for the SQL Server
    • Password: Password for the SQL Server
    • Database Name: leave this field blank
    • Server Group: <Default>

    New Connection Screen

Create a database

The following steps create a database named TutorialDB:

  1. Right click on your server, localhost, and select New Query.
  2. Paste the following snippet into the query window:

    USE master
    GO
    IF NOT EXISTS (
       SELECT name
       FROM sys.databases
       WHERE name = N'TutorialDB'
    )
    CREATE DATABASE [TutorialDB]
    GO
    
    ALTER DATABASE [TutorialDB] SET QUERY_STORE=ON
    GO
    
  3. To execute the query, click Run .

After the query completes, the new TutorialDB appears in the list of databases. If you don't see it, right-click the Databases node and select Refresh.

Create a table

The query editor is still connected to the master database, but we want to create a table in the TutorialDB database.

  1. Change the connection context to TutorialDB:

    Change context

  2. Paste the following snippet into the query window:

    -- Create a new table called 'Customers' in schema 'dbo'
    -- Drop the table if it already exists
    IF OBJECT_ID('dbo.Customers', 'U') IS NOT NULL
    DROP TABLE dbo.Customers
    GO
    -- Create the table in the specified schema
    CREATE TABLE dbo.Customers
    (
       CustomerId        INT    NOT NULL   PRIMARY KEY, -- primary key column
       Name      [NVARCHAR](50)  NOT NULL,
       Location  [NVARCHAR](50)  NOT NULL,
       Email     [NVARCHAR](50)  NOT NULL
    );
    GO
    

After the query completes, the new Customers table appears in the list of tables. You might need to right-click the TutorialDB > Tables node and select Refresh.

Insert rows

  1. Paste the following snippet into the query window:

    -- Insert rows into table 'Customers'
    INSERT INTO dbo.Customers
       ([CustomerId],[Name],[Location],[Email])
    VALUES
       ( 1, N'Orlando', N'Australia', N''),
       ( 2, N'Keith', N'India', N'keith0@adventure-works.com'),
       ( 3, N'Donna', N'Germany', N'donna0@adventure-works.com'),
       ( 4, N'Janet', N'United States', N'janet1@adventure-works.com')
    GO
    
  2. To execute the query, click Run.

View the data returned by a query

  1. Paste the following snippet into the query window:

    -- Select rows from table 'Customers'
    SELECT * FROM dbo.Customers;
    
  2. To execute the query, click Run.

    Select results

Next steps

Now that you've successfully connected to SQL Server and run a query, try out the Code editor tutorial.