CODEWITHSUNDEEP
sql-server
smya.dsh
smya.dsh

Reputation: 661

SQL Server lock due to select while inserting

I want to fetch some rows from a table while insertion is being done in that same table. While doing this operation, the table is being locked.

How can I fix this?

kindly help me out.

Thanks in advance

Upvotes: 3

Views: 2490

Answers (1)

sundar
sundar

Reputation: 1760

In case if you are using SQL Server 2008, then there is a provision to hint SQL Server to take row level lock.

Is it possible to force row level locking in SQL Server?

Upvotes: 2

Related Questions