Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier.

For example, let's say I'm updating 100 rows in a table. I'd like to know that a NULL is going to be inserted into a non-nullable field on one row via RAISEERROR, skip that row's update, and then ...

The third form of the CREATE TABLE statement stores the results of any query-expression in a table and does not display the output. It is a convenient way to create temporary tables that are subsets ...