SQL Summary

Functions

• General functions
  • EXECUTE
  • PRINT
  • RAISERROR
  • CHECKPOINT
  • KILL
  • RECONFIGURE
  • SHUTDOWN
  • NULL & UNKNOWN
  • USE
  • GO
• Aggregate functions
  • AVG
  • CHECKSUM_AGG
  • COUNT
  • GROUPING
  • MAX
  • MIN
  • STDEV
  • SUM
  • VAR

Language Elements

• General
  • Comment (— or /**/)
  • EXECUTE
  • PRINT
  • RAISERROR
• Flow control
  • BEGIN…END
  • IF…ELSE
  • WHILE
  • RETURN
  • THROW

Queries

• SELECT
• FROM + JOIN/APPLY
• WHERE
• GROUP BY
• HAVING
• ORDER BY

Statements

• General
  • DELETE
  • INSERT
  • UPDATE
• ALTER, CREATE, DROP
  • DATABASE
  • FUNCTION
  • INDEX
  • PROCEDURE
  • TABLE
  • TRIGGER
  • USER
  • VIEW
• Permissions
  • DENY
  • GRANT
  • REVOKE