You must Sign In to post a response.
  • Category: SQL Server

    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
    Use NOLOCK keyword in your stored procedure.
    Select * from tblEmp with (NOLOCK)
    May be helpful to you.

  • Sign In to post your comments