RSS feed

What is the use of nolock condition in SQL Query

Published by: Rinku (10/17/2008 7:29:10 PM)

OCT 17 2008

I am instructed by my DBA to use : with (nolock) indicator whenever i create joins on many tables. I dont really understand the need for the nolock criteria. The results of the query and the execution time is the same with or without the - with (nolock) indicator. So why use it. Can someone explain


when to use cast and when to use convert operator in SQL >>

<< How Can I Repair or Compact an MS Access Database in ASP



Name: samir kazi

when we fire a query on a table the query results a lock on a data in a table and if sum other user tries to retrieve the same data it doesnt firing a query with nolock results in making that or u can say row unlock so that other user can also access the same data at same time

You can use HTML tags here.
*Code: Please enter the sum of 5+2