How to do insert update and delete statement in sql

Belwo are the some rule to so insert update and delete

(1)Always try to use update and delete statement in the transaction for example use explicit commit.

(2)When you have to do update and delete statement first of all always create them on the basis of select satement after that do opertion on them.

(3)Now the last thing which have to remeber is execute the update and delete query on non-production server before doing this on production serv

er.