In order to run a query in Microsoft Operations Studio you must first to connect to a database on an instance of SQL Server.
It is so easy to connect to SQL Server database.
Step 1: Understand what is meant by Microsoft Operations Studio
Read here: What is Microsoft SQL Operations Studio?
Step 2: Get a handle on using this new Interface
Read here: Microsoft SQL Operations Studio User Interface
Step 3: Learn how you may connect to SQL Server (In this example SQL Server 2016 Developer)
Watch this video: Connecting to SQL Server 2016 Developer edition database using
Microsoft SQL Operations Studio
Step 4: Running a query on SQL Server after connecting to Northwind database
Now that you are connected, you can access all the tables, views, etc as shown.
When click on New Query icon in the Microsoft Operations Studio, the query plane is open as shown.
You will be required to enter a query starting at Line 1. When you type SEL, the Select statement begins.
You do not get the columns of employees as it is not yet even mentioned. Type in the rest of the query. Click Run. The results pane opens below the Select statement as shown.
The Results pane has a few controls on the right. This is cool. Now you can export the results to CSV, JSON or EXCEL. You could also view it as a chart.
Perhaps, SSMS should have a view of viewing data as chart.
In summary, it is easy to connect to SQL Server and run queries. It should be noted that there is no syntax check for queries as well as intellisense.
No comments:
Post a Comment