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

Pivot tables (crosstabs)

Relational division

Sequences

Spherical geometry         Great circle distance

Statistics without aggregates

Stored procedures

Strings