New answers tagged

2

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