Hi All, I would like to share a simple interview question. This is very simple yet many developers overlooks or not taking care of it. Do you know what happens to identity value if transaction fails? Do you think that identity value of table is unchanged after failure? Before looking at the solution below, try to memorize ACID properties of transaction and answer it. Check-out the POC shown below & wobble your mind 🙂