Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Query Behavour

Author  Topic 

khufiamalik
Posting Yak Master

120 Posts

Posted - 2008-09-11 : 05:47:19
Hello All,
if one Row is accessed by 2 different people through a query.
one of them updates the row and commits it to the DB.

The other person also updates the changes made by him.

Which one will be committed? and whether the LOOSER will get any Error message?

Thanks

mattyblah
Starting Member

49 Posts

Posted - 2008-09-11 : 05:55:43
Read up on Isolation Level.
Go to Top of Page
   

- Advertisement -