• It is a smart workaround, but it doesn't really solve the problem in an elegant way.

    I miss a configuration on Sql server that states "Where Clause mandatory". For all tables, for all Sql statements.

    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!

    But still if you need (and you will need) you can write "Where 1=1", to update/delete every record in a table.

    Your workaround treats it like a "missing where".

    You can see the difference between an accidentaly forgoten where and one you written on purpose.

    I believe this is a huge "security hole" in the Sql language. And yet it stays with us for so many years (and so many tears).