SQL Server Cheat Sheet

Connect to SQL Server

Server=myServerAddress;Database=myDataBase;
User Id=myUsername;Password=myPassword;

Basic Queries

SELECT * FROM Employees;
SELECT Name, Salary FROM Employees WHERE Salary > 50000;
INSERT INTO Employees (Name, Salary) VALUES ('John', 60000);
UPDATE Employees SET Salary = 70000 WHERE Name = 'John';
DELETE FROM Employees WHERE Name = 'John';

Joins

SELECT e.Name, d.DepartmentName
FROM Employees e
INNER JOIN Departments d ON e.DepartmentId = d.Id;

Stored Procedure

CREATE PROCEDURE GetEmployeeById @Id INT
AS
BEGIN
  SELECT * FROM Employees WHERE Id = @Id
END

Stored Procedures

CREATE PROCEDURE GetEmployeeById @Id INT
AS
BEGIN
  SELECT * FROM Employees WHERE Id = @Id
END

Joins

-- Inner Join
SELECT e.Name, d.Name AS DeptName
FROM Employees e
JOIN Departments d ON e.DeptId = d.Id

-- Left Join
SELECT e.Name, d.Name AS DeptName
FROM Employees e
LEFT JOIN Departments d ON e.DeptId = d.Id

Transactions

BEGIN TRANSACTION
UPDATE Accounts SET Balance = Balance - 100 WHERE Id = 1
UPDATE Accounts SET Balance = Balance + 100 WHERE Id = 2
COMMIT