Overview -- (Comment) Slash Star (Block Comment) CREATE DIAGNOSTICS SESSION NULL and UNKNOWN USE Backslash GO Control-of-Flow BEGIN...END BREAK CONTINUE ELSE (IF...ELSE) END (BEGIN...END) GOTO IF...ELSE RETURN THROW TRY...CATCH WAITFOR WHILE Cursors CLOSE DEALLOCATE DECLARE CURSOR FETCH OPEN Expressions CASE COALESCE NULLIF Operators Unary - Positive Unary - Negative Set - EXCEPT and INTERSECT Set - UNION Arithmetic + (Addition) += (Addition Assignment) - (Subtraction) -= (Subtraction Assignment) * (Multiplication) *= (Multiplication Assignment) / (Division) /= (Division Assignment) Modulus Modulus Assignment = (Assignment) Bitwise & (Bitwise AND) &= (Bitwise AND Assignment) | (Bitwise OR) |= (Bitwise OR Assignment) ^ (Bitwise Exclusive OR) ^= (Bitwise Exclusive OR Assignment) ~ (Bitwise NOT) Comparison = (Equals) > (Greater Than) < (Less Than) >= (Greater Than or Equal To) <= (Less Than or Equal To) <> (Not Equal To) !< (Not Less Than) != (Not Equal To) !> (Not Greater Than) Compound Logical ALL AND ANY BETWEEN EXISTS IN LIKE NOT OR SOME | ANY Scope Resolution String + (String Concatenation) += (String Concatenation Assignment) Percent character (Wildcard - Character(s) to Match) [ ] (Wildcard - Character(s) to Match) [^] (Wildcard - Character(s) Not to Match) _ (Wildcard - Match One Character) Operator Precedence Transactions Transactions Transaction Isolation Levels BEGIN DISTRIBUTED TRANSACTION BEGIN TRANSACTION COMMIT TRANSACTION COMMIT WORK ROLLBACK TRANSACTION ROLLBACK WORK SAVE TRANSACTION Variables SET @local_variable SELECT @local_variable DECLARE @local_variable EXECUTE PRINT-Transact-SQL RAISERROR CHECKPOINT KILL KILL QUERY NOTIFICATION SUBSCRIPTION KILL STATS JOB RECONFIGURE SHUTDOWN Reserved Keywords Syntax Conventions