Dummy question

[pap]

Hello,

For sure that this is a dummy question but can you explain me how SQL Server reacts to the fact that we have the same application running in two different pc's and this two applications intent to insert,update, delete or even read a record from the same table

Does "he" blocks the record until one of them leave the table ??? And if the other tries to update at the same time ???

Thanks,
Paulo

[rmiao]

They can read from same table at same time, but not other processes. You can use row level locking to reduce blocking.

[pap]

First of all thank you for your time,

How can I do this 'row level locking' ?

Thanks,
Paulo

[YuckFou]

see this ... http://www.sql-server-performance.com/blocking.asp

[rmiao]

Or check it in sql books online.

[skhanal]

If you are using sql 7.0 or 2000, you don't have to do anything to use row level locking, it's used by default.

[rmiao]

You can enforce it with locking hint 'rowlock'.

[Saurin]

Where can i find the SQL Books Online
also can u tell me where can i find more information like basic and advanced queries and tutorials for advanced SQL

Thank you

Saurin

[MAK]

If you have SQL Server installed on your machine, it comes with BOL (books On Line) also called as HELP.

For basic ANSI SQL learning go to www.sqlcourse.com

For advanced SQL learning you have to learn from BOL and forums like this.