• Great article!

    I particularly enjoy the OUTPUT clause.  One of the thing that I bi***, er, gripe about is data archiving.  It is usually left out of designs until the server fills up.   This will be a great boon as I can now write my archive function with only one statement per table and wrap the whole thing in a transaction.  My archive database is an exact copy, structurally, of the production database.

    ATBCharles Kincaid