It is really no different from running a query in SQL Server
Management Studio. You need to have an instance of SQL Server running on
your computer. Launch HeidiSQL and get connected to the instance.
You will be seeing this (different in your case) displayed in the HeidiSQL user interface. Either you can get connected to a session you created or a new one using the New button at the bottom of the UI.
RunAQuery01.png
You can connect to a single database by selecting it from the list as shown. Here Northwind was selected.
RunAQuery02.png
The Nov21 sessions gets changed and the changed sessions window opens as shown:
RunAQuery03.png
Click on Query to open a window for inserting query related statements as shown:
RunAQuery04.png
In the Query Window insert your SQL statement. For example a query such as the one shown:
SELECT TOP 50 [CategoryName]
,[ProductName]
,[ProductSales]
FROM [Northwind].[dbo].[Product Sales for 1997]
Click Query and the response will appear below the query window as shown.
RunAQuery07.png
The tabbed window in the center has all the necessary tabs like the SAP SQLAnywhere Studio Central.
You will be seeing this (different in your case) displayed in the HeidiSQL user interface. Either you can get connected to a session you created or a new one using the New button at the bottom of the UI.
RunAQuery01.png
You can connect to a single database by selecting it from the list as shown. Here Northwind was selected.
RunAQuery02.png
The Nov21 sessions gets changed and the changed sessions window opens as shown:
RunAQuery03.png
Click on Query to open a window for inserting query related statements as shown:
RunAQuery04.png
In the Query Window insert your SQL statement. For example a query such as the one shown:
SELECT TOP 50 [CategoryName]
,[ProductName]
,[ProductSales]
FROM [Northwind].[dbo].[Product Sales for 1997]
Click Query and the response will appear below the query window as shown.
RunAQuery07.png
The tabbed window in the center has all the necessary tabs like the SAP SQLAnywhere Studio Central.
No comments:
Post a Comment