T-SQL Keywords
Functions
Schema
Potpourri
Four Letter Words
100
This keyword introduces all read queries.
What is select?
100
This function gets the current date and time.
What is GetDate?
100
This is the container for tables in SQL Server.
What is the database?
100
This symbol is used at the beginning of variable or parameter names.
What is "@"?
100
These come in inner and outer varieties.
What is a join?
200
These keywords provide the "sorting" capability in T-SQL.
What is "order by?"
200
Our book referred to this as a function, though it is really a conditional structure similar to the "switch" keyword in JavaScript.
What is case?
200
This type of key is generated on a "many" table and points to a record on a "one" table.
What is a foreign key?
200
This "specification" enables the creation of an auto-increment column.
What is identity?
200
This word is an acronym for the types of operations in sql that allow us to ask for and manipulate data in the database.
What is CRUD?
300
This type of join produces a Cartesian product between all rows of each table referenced.
What is a cross join?
300
This function removes the leading spaces from a string.
What is "LTRIM?"
300
This is the default "schema" in SQL Server and is used exclusively in Northwind.
What is "dbo?"
300
The keyword that removes duplicates from a result set.
What is distinct?
300
This data type contains a specific number of string characters. No more, no less.
What is "char?"
400
This two letter keyword is the default batch delineator in SQL Server.
What is "go?"
400
The function that helps us avoid nulls by outputting the first non-null value from a list of values or expressions.
What is coalesce?
400
These characters should precede the name of your temp table if you want it to be available to more than one connected session.
What is "##?"
400
The keyword that sorts a result set in a "Z to A" order.
What is DESC?
400
This four letter word may lead to others as it deletes all data and structure for a given table.
What is "drop?"
500
This keyword creates an inclusive range within a where clause.
What is between?
500
This conditional function can swap out a number for an associated value in 1...2...3 order.
What is choose?
500
Creating a primary key automatically creates this kind of index, which can physically reorder records in a table on disk.
What is a clustered index?
500
This SQL keyword can be used with a UNION to produce a query where rows that are matched between two tables are returned, like an inner join.
What is INTERSECT?
500
This keyword allows for variable length or inexact string-based queries that include a wildcard character.
What is like?
M
e
n
u