Do not want to lock the table

  • Thread starter Thread starter June
  • Start date Start date
J

June

Hi, All,

In ADO.NET, when executing sql statement, the table will be locked.
Except for using "with nolock" in the sql statement to avoid locking
the table, is there any other ways that can get the same result?

Please help. Thanks in advance.
 
Hi June,

Table locks are rarely applied. What sort of statement are you executing
that's causing a table lock?

Regards,
 
Back
Top