Aggregates

Data comparison

Database metadata         Add auto-incrementing primary key to a table         Auto-increment: reset next value         Change or drop a foreign key         Compare structures of two tables         Compare two databases         Database size         Find child tables         Find parent tables         Find primary key of a table         Find the size of all databases on the server         List databases, tables, columns         List differences between two databases         List users of a database         Rename Database         Replace text in all string columns of a database         Show

Date and time

Frequencies

Graphs and Hierarchies

JOIN

NULLs

Ordering resultsets         Emulate Row_Number()         Next row         Order by leading digits         Order by month name         Order by numerics then alphas         Pagination         Suppress repeating ordering values

Pivot tables (crosstabs)

Relational division

Sequences

Spherical geometry         Great circle distance

Statistics without aggregates

Stored procedures

Strings