Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The use of NOLOCK
Message
 
 
To
16/02/2009 19:10:04
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01382232
Message ID:
01382250
Views:
44
>On a specific SQL command, if I use NOLOCK, does this mean I can get innaccurate data up to several minutes ago, or worst? Or, is it just within some fractions of a second?

You will get extra data from uncommited related transaction that exist at the time of your query.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform