Hesitation production psychological SQL Blues

[byterbit]

When writing SQL scripts to update my largest client’s system I find that, unlike my psychology with looping code , I hesitate to run my instructions. I double check myself, write test quires to verify recordsets, create test tables to run against and in general waste an incredible amount of time. Is this normal ? I’m not exactly a newbie with SQL (16 years ? more ?) , and my stuff works, when I run it. Is it that I test each bit of my VBA code as I write the loops and so trust it more ? Is it that I don’t want to lose my customer ?


Is this a common condition ?

[khalid]

This is a psychological question. If you have 16 years or more experience of writing SQL queries, then you should have strong confidence on each query you write, however I prefer testing the SQL queries on local test copy of the database to avoid a BIG mess to the database...

Regards,
Khalid Afridi