I want to perform SQL transaction when insertion of new rows only.
what type of transaction isolation level I should follow.
I want to perform SQL transaction when insertion of new rows only.
what type of transaction isolation level I should follow.
Read this to understand your requirement. SET TRANSACTION ISOLATION LEVEL
Either of the two should suit you:
READ UNCOMMITTED Specifies that statements can read rows that have been modified by other transactions but not yet committed.
READ COMMITTED Specifies that statements cannot read data that has been modified but not committed by other transactions. This prevents dirty reads. Data can be changed by other transactions between individual statements within the current transaction, resulting in nonrepeatable reads or phantom data. This option is the SQL Server default.