Can someone explain isolation level serializable?
if two processes run the same stored proc,
Set transaction isolation level serializable
declare @currentnum int
Select @currentnum = currentnum from refnumbers where id = 1;
update refnumbers set currentnum =
@currentnum where id = 1;
so if user1 and user2 run the select query at the same time, does it mean user2 will not be able to select anything until user1 transaction commits? keep in mind user1 has not ran the update yet, both users are running select.
Can you also explain how serializable level eliminates lost updates?