How to Execute a Query in SQL Server Management Studio

Download Microsoft SQL Server Management Studio (SSMS) for free on the Microsoft website.

For a list of Queries to test, visit our webpage Sample Queries.

Execute a Query in SQL Server Management Studio

  1. Open Microsoft SQL Server Management Studio. Microsoft SQL Server Management Studio

  2. Select [New Query] from the toolbar.SQL Server Management Studio New Query

  3. Copy the 'Example Query' below, by clicking the [Copy Text] button.

    SELECT * FROM Entity

  4. Select the database to run the query against, paste the 'Example Query' into the query window. Click the [Execute] button. Microsoft SQL Server Management Studio Execute Query

Microsoft Certified Partner

Microsoft Partner Network

Partners Welcome

Do you provide services to government and commercial customers seeking analytic solutions?
Contact us

In-Q-Tel Portfolio Company

InQTel Portfolio Company
Learn more