SQL Server

Overview
This page will display information, tips, and query strategies for SQL Server Transact-SQL language.

SQL Shortcuts

 * CTRL+E = execute query
 * CTRL+KC = Quick Comment
 * CTRL+KU = Quick Uncomment

SQL Notes

 * Select which database to use when writing a query from someone (use Loop1_NPM)
 * Null is absence of information - never had a value
 * Before working with a SQL Database realize the relationship of the databases between tables.
 * 1:1 - 1 Husband : 1 Wife
 * 1:M - 1 Parent : Many Kids
 * M:M - Teachers : Students

Keywords of SQL query language

 * 1) select (field select)
 * 2) from (table)
 * 3) where (rows)
 * 4) sysname
 * 5) insert
 * 6) update
 * 7) delete
 * 8) having
 * 9) between
 * 10) line
 * or
 * and
 * not
 * in
 * 1) order
 * 2) group
 * by