Getting started with SQL
ALTER TABLE
AND & OR Operators
CASE
CREATE Database
CREATE FUNCTION
CREATE TABLE
Cascading Delete
Clean Code in SQL
Comments
Common Table Expressions
DELETE
DROP Table
DROP or DELETE Database
Data Types
EXCEPT
EXISTS CLAUSE
EXPLAIN and DESCRIBE
Example Databases and Tables
Execution blocks
Filter results using WHERE and HAVING
Finding Duplicates on a Column Subset with Detail
Foreign Keys
Functions (Aggregate)
Functions (Analytic)
Functions (Scalar/Single Row)
GRANT and REVOKE
GROUP BY
IN clause
INSERT
Identifier
Indexes
Information Schema
JOIN
LIKE operator
MERGE
Materialized Views
NULL
ORDER BY
Order of Execution
Primary Keys
Relational Algebra
Row number
SELECT
SKIP TAKE (Pagination)
SQL CURSOR
SQL Group By vs Distinct
SQL Injection
Sequence
Stored Procedures
String Functions
Subqueries
Synonyms
TRUNCATE
TRY/CATCH
Table Design
Transactions
Triggers
UNION / UNION ALL
UPDATE
Views
Window Functions
XML
cross apply, outer apply

Synonyms

Create Synonym

CREATE SYNONYM EmployeeData
FOR MyDatabase.dbo.Employees

← Subqueries
TRUNCATE →

This modified text is an extract of the original Stack Overflow Documentation created by the contributors and released under CC BY-SA 3.0 This website is not affiliated with Stack Overflow