Question on SQL before switching to sql server.

[Wolfen12]

Hi People

I want to switch to SQL server.What is very important to know for me before I do this switch:

What happens if 2 users work exactly the same time on a record?
In free Tables you lock a record when u use it, the other user wil get a message that the record is locked.

Will this happen in sql server also or does it only update the last persons changes

Thank you

 

[onpnt]

Any database server will do that. If two transactions come in at the same time one will go into a wait state and be applied once the first is completed. If you are refering to setting transaction locks on the table for a length of time then a SQLException will be returned that your development side will need to handle. That is no different either.

This does not of course take into account discussing deadlocks but those concerns are the same across database servers in general again.


[sub]____________ signature below ______________
I am Tedward Keyboardhands!!!
You are a amateur developer until you realize all your code sucks.
Jeff Atwood[/sub]