Home Forums Article Discussions Article Discussions by Author Discuss content posted by Rahul Kr. Ghosh Automated Trigger To Require a WHERE Clause RE: Automated Trigger To Require a WHERE Clause

  • January 25, 2011 at 1:22 am

    #1277648

    luciano furlan (1/25/2011)

    I fear every day, that I will forget the where clause eventually and destroy an entire table.

    And guess what: Sql doesn't have an Undo button!

    If you're doing anything on a production server, the first command in your query window and the first you run should be BEGIN TRANSACTION. That way if you do accidentally leave out (or not select) the where clause, you can roll it back.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass