- name: Overview

href: language-elements-transact-sql.md

- name: "-- (Comment)"

href: comment-transact-sql.md

- name: Slash Star (Block Comment)

href: slash-star-comment-transact-sql.md

- name: CREATE DIAGNOSTICS SESSION

href: create-diagnostics-session-transact-sql.md

- name: NULL and UNKNOWN

href: null-and-unknown-transact-sql.md

- name: USE

href: use-transact-sql.md

- name: Backslash (Line Continuation)

href: sql-server-utilities-statements-backslash.md

- name: GO

href: sql-server-utilities-statements-go.md

- name: Control-of-Flow

href: control-of-flow.md

items:

- name: BEGIN...END

href: begin-end-transact-sql.md

- name: BREAK

href: break-transact-sql.md

- name: CONTINUE

href: continue-transact-sql.md

- name: ELSE (IF...ELSE)

href: else-if-else-transact-sql.md

- name: END (BEGIN...END)

href: end-begin-end-transact-sql.md

- name: GOTO

href: goto-transact-sql.md

- name: IF...ELSE

href: if-else-transact-sql.md

- name: RETURN

href: return-transact-sql.md

- name: THROW

href: throw-transact-sql.md

- name: TRY...CATCH

href: try-catch-transact-sql.md

- name: WAITFOR

href: waitfor-transact-sql.md

- name: WHILE

href: while-transact-sql.md

- name: Cursors

href: cursors-transact-sql.md

items:

- name: CLOSE

href: close-transact-sql.md

- name: DEALLOCATE

href: deallocate-transact-sql.md

- name: DECLARE CURSOR

href: declare-cursor-transact-sql.md

- name: FETCH

href: fetch-transact-sql.md

- name: OPEN

href: open-transact-sql.md

- name: Expressions

href: expressions-transact-sql.md

items:

- name: CASE

href: case-transact-sql.md

- name: COALESCE

href: coalesce-transact-sql.md

- name: NULLIF

href: nullif-transact-sql.md

- name: Operators

href: operators-transact-sql.md

items:

- name: Unary - Positive

href: unary-operators-positive.md

- name: Unary - Negative

href: unary-operators-negative.md

- name: Set - EXCEPT and INTERSECT

href: set-operators-except-and-intersect-transact-sql.md

- name: Set - UNION

href: set-operators-union-transact-sql.md

- name: Arithmetic

href: arithmetic-operators-transact-sql.md

items:

- name: "+ (Addition)"

href: add-transact-sql.md

- name: "+= (Addition Assignment)"

href: add-equals-transact-sql.md

- name: "- (Subtraction)"

href: subtract-transact-sql.md

- name: "-= (Subtraction Assignment)"

href: subtract-equals-transact-sql.md

- name: "* (Multiplication)"

href: multiply-transact-sql.md

- name: "*= (Multiplication Assignment)"

href: multiply-equals-transact-sql.md

- name: "/ (Division)"

href: divide-transact-sql.md

- name: "/= (Division Assignment)"

href: divide-equals-transact-sql.md

- name: "% Modulus"

href: modulo-transact-sql.md

- name: "%= Modulus Assignment"

href: modulo-equals-transact-sql.md

- name: "= (Assignment)"

href: assignment-operator-transact-sql.md

- name: Bitwise

href: bitwise-operators-transact-sql.md

items:

- name: "& (Bitwise AND)"

href: bitwise-and-transact-sql.md

- name: "&= (Bitwise AND Assignment)"

href: bitwise-and-equals-transact-sql.md

- name: "| (Bitwise OR)"

href: bitwise-or-transact-sql.md

- name: "|= (Bitwise OR Assignment)"

href: bitwise-or-equals-transact-sql.md

- name: "^ (Bitwise Exclusive OR)"

href: bitwise-exclusive-or-transact-sql.md

- name: "^= (Bitwise Exclusive OR Assignment)"

href: bitwise-exclusive-or-equals-transact-sql.md

- name: "~ (Bitwise NOT)"

href: bitwise-not-transact-sql.md

- name: Comparison

href: comparison-operators-transact-sql.md

items:

- name: "= (Equals)"

href: equals-transact-sql.md

- name: "> (Greater Than)"

href: greater-than-transact-sql.md

- name: "< (Less Than)"

href: less-than-transact-sql.md

- name: ">= (Greater Than or Equal To)"

href: greater-than-or-equal-to-transact-sql.md

- name: "<= (Less Than or Equal To)"

href: less-than-or-equal-to-transact-sql.md

- name: "<> (Not Equal To)"

href: not-equal-to-transact-sql-traditional.md

- name: "!< (Not Less Than)"

href: not-less-than-transact-sql.md

- name: "!= (Not Equal To)"

href: not-equal-to-transact-sql-exclamation.md

- name: "!> (Not Greater Than)"

href: not-greater-than-transact-sql.md

- name: Compound

href: compound-operators-transact-sql.md

- name: Logical

href: logical-operators-transact-sql.md

items:

- name: ALL

href: all-transact-sql.md

- name: AND

href: and-transact-sql.md

- name: ANY

href: any-transact-sql.md

- name: BETWEEN

href: between-transact-sql.md

- name: EXISTS

href: exists-transact-sql.md

- name: IN

href: in-transact-sql.md

- name: LIKE

href: like-transact-sql.md

- name: NOT

href: not-transact-sql.md

- name: OR

href: or-transact-sql.md

- name: SOME | ANY

href: some-any-transact-sql.md

- name: ":: (Scope Resolution)"

href: scope-resolution-operator-transact-sql.md

- name: String

href: string-operators-transact-sql.md

items:

- name: "+ (String Concatenation)"

href: string-concatenation-transact-sql.md

- name: "+= (String Concatenation Assignment)"

href: string-concatenation-equal-transact-sql.md

- name: "% (Wildcard - Character(s) to Match)"

href: percent-character-wildcard-character-s-to-match-transact-sql.md

- name: "[ ] (Wildcard - Character(s) to Match)"

href: wildcard-character-s-to-match-transact-sql.md

- name: "[^] (Wildcard - Character(s) Not to Match)"

href: wildcard-character-s-not-to-match-transact-sql.md

- name: "_ (Wildcard - Match One Character)"

href: wildcard-match-one-character-transact-sql.md

- name: Operator Precedence

href: operator-precedence-transact-sql.md

- name: Transactions

href: transactions-transact-sql.md

items:

- name: Transactions

href: transactions-sql-data-warehouse.md

- name: Transaction Isolation Levels

href: transaction-isolation-levels.md

- name: BEGIN DISTRIBUTED TRANSACTION

href: begin-distributed-transaction-transact-sql.md

- name: BEGIN TRANSACTION

href: begin-transaction-transact-sql.md

- name: COMMIT TRANSACTION

href: commit-transaction-transact-sql.md

- name: COMMIT WORK

href: commit-work-transact-sql.md

- name: ROLLBACK TRANSACTION

href: rollback-transaction-transact-sql.md

- name: ROLLBACK WORK

href: rollback-work-transact-sql.md

- name: SAVE TRANSACTION

href: save-transaction-transact-sql.md

- name: Variables

href: variables-transact-sql.md

items:

- name: SET @local_variable

href: set-local-variable-transact-sql.md

- name: SELECT @local_variable

href: select-local-variable-transact-sql.md

- name: DECLARE @local_variable

href: declare-local-variable-transact-sql.md

- name: EXECUTE

href: execute-transact-sql.md

- name: PRINT

href: print-transact-sql.md

- name: RAISERROR

href: raiserror-transact-sql.md

- name: CHECKPOINT

href: checkpoint-transact-sql.md

- name: KILL

href: kill-transact-sql.md

- name: KILL QUERY NOTIFICATION SUBSCRIPTION

href: kill-query-notification-subscription-transact-sql.md

- name: KILL STATS JOB

href: kill-stats-job-transact-sql.md

- name: RECONFIGURE

href: reconfigure-transact-sql.md

- name: SHUTDOWN

href: shutdown-transact-sql.md

- name: Reserved Keywords

href: reserved-keywords-transact-sql.md

- name: Syntax Conventions

href: transact-sql-syntax-conventions-transact-sql.md