SQL · Theory

Using SQL Server Management Studio to connect to SQL Server

Theory

432/439

Using SQL Server Management Studio to connect to SQL Server

Using SQL Server Management Studio to connect to SQL Server is a practical MySQL task. Split it: (1) is the server running? (2) can this client connect (host, port 3306, user, password)? (3) USE the right database?

Install / Workbench / Docker / XAMPP all still end at: mysql -u user -p or a GUI connection with the same four fields. If Workbench says cannot connect, the server is down or the password/host is wrong — not ‘SQL is broken’.

Remote access: bind-address, user@'%', firewall, never open root to the world. Docker: port map 3306, MYSQL_ROOT_PASSWORD env.

Trap — installing only the client. Trap: two MySQL services fighting on 3306.

Exam tip

Server up? Then connect with user@host. SELECT VERSION();

Using SQL Server Management Studio to connect to SQL Server — sample query

-- Using SQL Server Management Studio to connect to SQL Server
CREATE TABLE demo (
  id INTEGER PRIMARY KEY,
  label TEXT NOT NULL,
  qty INTEGER DEFAULT 0
);
INSERT INTO demo (id, label, qty) VALUES
  (1, 'alpha', 2),
  (2, 'beta', 5);
SELECT label, qty FROM demo WHERE qty >= 2 ORDER BY qty DESC;

Using SQL Server Management Studio to connect to SQL Server: create two demo rows, then SELECT qty >= 2 ordered. Say which labels come back.

Short notes

DefUsing SQL Server Management Studio to connect to SQL Server — server running + client login.
Rulehost, 3306, user, password, database.
TrapGUI without mysqld. Two servers on 3306.

-- Using SQL Server Management Studio to connect to SQL Server CREATE TABLE demo ( id INTEGER PRIMARY KEY, label TEXT NOT NULL, qty INTEGER DEFAULT 0 ); INSERT INTO demo (id, label, qty) VALUES (1, 'alpha', 2), (2, 'beta', 5); SELECT label, qty FROM demo WHERE qty >= 2 ORDER BY qty DESC;

Using SQL Server Management Studio to connect to SQL Server

Using SQL Server Management Studio to connect to SQL Server — sample query

Short notes

Questions

Using SQL Server Management Studio to connect to SQL Server

Using SQL Server Management Studio to connect to SQL Server — sample query

Short notes

Questions