Aggregates

Data comparison         Backslashes in data         Compare data in two tables         Show rows where column value changed

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         List NULLs at end of query output         Parents with and without children

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         Count delimited substrings         Count substrings         Levenshtein distance         Proper case         Retrieve octets from IP addresses         Return digits or alphas from a string         Strip HTML tags