How does "ROWLOCK" work? I have this situation:
User1 - Query Analyzer begin transaction update t1 with (rowlock) set c1 = 10 where c1 = 5 User 2 - Query Analyzer update t1 with (rowlock) set c1 = 20 where c1 =... Ask the Expert | SearchSQLServer.com
Everyone familiar with SQL Server should be familiar with the row-locking mechanism: any row in a table that is being updated or read will be row-locked to keep other processes from changing it or reading data that may be modified. There are... Tip | SearchSQLServer.com
I am trying to create unique document numbers for my transactions. I have an order that has an order segement and a segement number. The document is in the following form: "segment number/segment".
I have a deadlock... Ask the Expert | SearchSQLServer.com