Use Excel to DIFF Your Query Outputs

Comparing data from two queries to see if they return the same results can be an interesting challenge. David Ziffer brings us a great way to do this using Excel.

Triggers

SQL inner and outer joins: Basics for getting started

Learn the basics to create a SQL inner join and SQL outer join. Get examples on how to use them for a customized result set querying more than one table.

Query Hints

CURRENT_TIMESTAMP

Power and Deception of CTEs

A performance problem with a CTE based stored procedure, opened the developers eyes to a whole new world

Table Variables

TSQL

The Numbers Table

Having a table of just numbers can be very handy, and it doesn't necessarily take up much space in your database. New author Brandon Galderisi brings us a short tutorial on setting this up.

Extracting a Numeric Reference from a VARCHAR field