Problem while accessing the committed data + sql server 2005
-
Hi, I was trying the extract the records from a table which is currently used by some other user for updation/insertion. My question is , Is there any way to read the committed data for a row which is presently locked because updation on this row is going on and transaction is not completed. Thanks
-
Hi, I was trying the extract the records from a table which is currently used by some other user for updation/insertion. My question is , Is there any way to read the committed data for a row which is presently locked because updation on this row is going on and transaction is not completed. Thanks
use NoLock for dirty reading Select cloumnName from Table with NoLock
himanshu
-
use NoLock for dirty reading Select cloumnName from Table with NoLock
himanshu
Hi, Suppose i update the row Begin tran Update table set column = 'some val' where id = 9 it's original value is val now suppose transaction completes after some time, and mean while a user selects this table and the user should read val not some val Any Idea? I dn't want to ready dirty data and also don'y want the query to get blocked