How to Execute a Query in SQL Server Management Studio

1. Open Microsoft SQL Server Management Studio and connect to your SQL Server (Database Engine):
   
2. Connect to your SQL Server. If you installed the Sentinel Visualizer sample database, it is named MyPC\SENT4EXPRESS, where MyPC is your machine name. You can use Windows Authentication to connect:
   
3. Your connected server appears on the Object Explorer:
   
4. Select your database from the database folder.
   
5. Click [New Query] on the toolbar.
   

6. Copy the sample SQL query by clicking the [Copy Text] button.

   SELECT * FROM Entity

   Copy text

   There are more examples on this webpage: Sample Queries.

7. Paste the SQL query into the query window.
   
8. Click the [Execute] button or press [F5] to run it. The results appear in the section below the query:
   
   If there were any problems with your query, error messages appear on the Messages tab.

Tips

• Press [Ctrl] R to toggle the visibility of Results section. This gives you more room to see and write your queries.
• You can open multiple New Query Windows.