Overview) -- (Comment) Slash Star 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 + (Add) += (Add EQUALS) - (Subtract) -= (Subtract EQUALS) * (Multiply) *= (Multiply EQUALS) (Divide) /= (Divide EQUALS) Modulo Modulo EQUALS Assignment Bitwise & (Bitwise AND) &= (Bitwise AND EQUALS) | (Bitwise OR) |= (Bitwise OR EQUALS) ^ (Bitwise Exclusive OR) ^= (Bitwise Exclusive OR EQUALS) ~ (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) 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