Microsoft SQL Server IDE

Microsoft SQL Server is a proprietary relational database management system developed by Microsoft. qStudio is a free SQL IDE, it allows running SQL scripts, easy browsing of tables, charting and exporting of results. It works on every operating system, with every database including Microsoft SQL Server.

Start Microsoft SQL Server
Connecting to Microsoft SQL Server
Querying Microsoft SQL Server

Setting up a Microsoft SQL Server connection in qStudio

Start Microsoft SQL Server

Microsoft SQL Server can either be ran locally or on the various cloud vendors including ms azure. For this example we ran MS SQL Server Express 2019 locally. The connection details should be provided, similar to shown:

Make sure SQL and Windows security logon is turned on.
That TCP logins are enabled.

Connecting to a Server

QStudio bundles the JDBC driver for Microsoft SQL Server.

When you first open qStudio click on the menu options Server->Add Server or on the add server button on the toolbar.
Then set the details:

Server Type: Microsoft SQL Server
Host: localhost
Port: 1443
Username: sa
Password: XXXXXXXXXXX
Click Add

Sending Queries

CREATE SCHEMA sales;

CREATE TABLE sales.orders (
	order_id INT IDENTITY (1, 1) PRIMARY KEY,
	customer_id INT NULL,
	order_status tinyint NOT NULL,
	-- Order status: 1 = Pending; 2 = Processing; 3 = Rejected; 4 = Completed
	order_date DATE NOT NULL,
	required_date DATE NOT NULL,
	shipped_date DATE,
	store_id INT NULL,
	staff_id INT NULL
);

SET IDENTITY_INSERT sales.orders ON; 
INSERT INTO sales.orders(order_id, customer_id, order_status, order_date, required_date, shipped_date, store_id,staff_id) VALUES(1,259,4,'20160101','20160103','20160103',1,2);
INSERT INTO sales.orders(order_id, customer_id, order_status, order_date, required_date, shipped_date, store_id,staff_id) VALUES(2,1212,4,'20160101','20160104','20160103',2,6);
INSERT INTO sales.orders(order_id, customer_id, order_status, order_date, required_date, shipped_date, store_id,staff_id) VALUES(3,523,4,'20160102','20160105','20160103',2,7);
INSERT INTO sales.orders(order_id, customer_id, order_status, order_date, required_date, shipped_date, store_id,staff_id) VALUES(4,175,4,'20160103','20160104','20160105',1,3);
INSERT INTO sales.orders(order_id, customer_id, order_status, order_date, required_date, shipped_date, store_id,staff_id) VALUES(5,1324,4,'20160103','20160106','20160106',2,6);
INSERT INTO sales.orders(order_id, customer_id, order_status, order_date, required_date, shipped_date, store_id,staff_id) VALUES(6,94,4,'20160104','20160107','20160105',2,6);
INSERT INTO sales.orders(order_id, customer_id, order_status, order_date, required_date, shipped_date, store_id,staff_id) VALUES(7,324,4,'20160104','20160107','20160105',2,6);
INSERT INTO sales.orders(order_id, customer_id, order_status, order_date, required_date, shipped_date, store_id,staff_id) VALUES(8,1204,4,'20160104','20160105','20160105',2,7);
INSERT INTO sales.orders(order_id, customer_id, order_status, order_date, required_date, shipped_date, store_id,staff_id) VALUES(9,60,4,'20160105','20160108','20160108',1,2);
INSERT INTO sales.orders(order_id, customer_id, order_status, order_date, required_date, shipped_date, store_id,staff_id) VALUES(10,442,4,'20160105','20160106','20160106',2,6);
INSERT INTO sales.orders(order_id, customer_id, order_status, order_date, required_date, shipped_date, store_id,staff_id) VALUES(11,1326,4,'20160105','20160108','20160107',2,7);
INSERT INTO sales.orders(order_id, customer_id, order_status, order_date, required_date, shipped_date, store_id,staff_id) VALUES(12,91,4,'20160106','20160108','20160109',1,2);
SET IDENTITY_INSERT sales.orders OFF; 
SELECT * FROm sales.orders;

You can run queries by highlighting selected code and pressing Ctrl + e to run that code. See Keyboard Shortcuts.

Command	Shortcut
Run highlighted text	Ctrl + e
Run Line	Ctrl + Enter

This will update your various results panels, result contains your table (excel export etc. supported), charts are generated based on your data and the console summarizes your recent commands

Well Done!

You have now got qStudio querying your database successfully.

We want to make qStudio the best SQL analysis tool. If you have any problems or want additional features, please post on our github repo.