• The SQL server' default is Auto commit which is Read committed transaction,here each command is a single transaction so once the loop run each and every record is auto committed to the database.

    I still don't completely understand what you're trying to do or why it has to be done in a loop.

    Since i am measuring the total insertion time for bunch of loop values 1,5,50,100.... 10000k.

    The article which you have tagged does not contain any insert statement options rather it is having Select statement.I am just using a prepare statement (which may be java ,.net,C#,Vc++ and so on) and measuring the time.

    I am just checking what is the time take for different loop values.

    Thanks!