\[ \let\oldlor\lor \renewcommand{\lor}{\; \oldlor \;} \let\oldland\land \renewcommand{\land}{\; \oldland \;} \renewcommand{\set}[1]{\{\, #1 \,\}} \renewcommand{\given}{\,\mid\,} \renewcommand{\abs}[1]{\lvert #1 \rvert} \renewcommand{\divs}{\!\;\mid\;\!} \renewcommand{\ndivs}{\!\;\nmid\;\!} \renewcommand{\betw}[3][1]{#1 \leq #2 \leq #3} \renewcommand{\mod}[1]{\ (\mathrm{mod}\ #1)} \renewcommand{\floor}[1]{\left \lfloor #1 \right \rfloor} \renewcommand{\ceil}[1]{\left \lceil #1 \right \rceil} \renewcommand{\t}[1]{\texttt{#1}} \renewcommand{\fori}[2][i]{\text{for } #1 = 0, 1, \dots, #2} \renewcommand{\x}[1]{\text{#1}} \renewcommand\concat{\mathbin{+\mkern-10mu+}} \DeclareMathOperator*{\CONCAT}{\concat} \DeclareMathOperator*{\SCC}{\|} \]

T-SQL and Databases

Learn about SQL. Primarily focused on SQL Server (Microsoft) using MSSQL/T-SQL query language.
Posts
Title Description Tags
T-SQL: Create and insert Create tables and insert data
T-SQL: Delete and truncate Delete rows, tables, and other objects
T-SQL: Insert Inserting new rows
T-SQL: Schemas Interact with schema objects
T-SQL: Merge Insert, delete, or update according to merge expression
T-SQL: Triggers DML Triggers
T-SQL: Update The UPDATE statement for data modification
Stored Procedures Creating and using stored procedures
BCP Bulk copy program
INTERSECT and EXCEPT Use EXCEPT to filter rows from your query
Handy Snippets Assorted T-SQL snippets that you may find useful
Online Resources for T-SQL Useful links, blogs, and web resources for T-SQL