You must Sign In to post a response.

16 Sep 2019 21:30

Joined:	06/09/2011
Level:	Silver
Points:	106

Points:	2

How to avoid locks in stored procedure

i have temp table with sample data, same data i m inserting into main table, from main table to another two tables. while inserting into main table happening sql locks which is giving low performance of application. can u please help how to avoid such type of locks
while inserting or updating

#769973

27 Sep 2019 16:53

Joined:	06/03/2012
Level:	Silver
Points:	461

Points:	2

Use NOLOCK keyword in your stored procedure.
e.g.
Select * from tblEmp with (NOLOCK)
----------------------------------
May be helpful to you.

Submit New Thread

Return to Return to Discussion Forum

How to avoid locks in stored procedure

About dotnetspider.com

Quick Links

General

Services