New answers tagged


I should not use IF SELECT before doing an UPDATE statement because it will breaks the atomicity of a transaction This is wrong. The if exists / update is itself a non-atomic operation, but since it exists within the context of a transaction, ACID will be preserved. If there were no transaction, no isolation level would be applied and integrity would not be ...

Top 50 recent answers are included