Friday, February 17, 2012

Concurrency question

Suppose process A is updating record #1 in table T.
By default, can other processes read record #1 while the updating is in progress ??
If the answer is Yes, then which value can they see - the old one or the new one ?
Thank you in advance.Check this...

http://www.sql-server-performance.com/at_sql_locking.asp

No comments:

Post a Comment