Top "Rowlocking" questions

Row locking refers to when a database record is updated and the SQL engine locks the row to ensure referential integrity

Is it possible to force row level locking in SQL Server?

I can see how to turn off row level and page level locking in SQL Server, but I cannot find …

sql-server sql-server-2005 sql-server-2008 rowlocking
How to totally lock a row in Entity Framework

I am working with a situation where we are dealing with money transactions. For example, I have a table of …

c# sql-server entity-framework entity-framework-6.1 rowlocking
I need row-level locking

This is an extension to Is it possible to force row level locking in SQL Server?. Here is the use …

sql-server rowlocking
How many rows will be locked by SELECT ... ORDER BY xxx LIMIT 1 FOR UPDATE?

I have a query with the following structure: SELECT ..... WHERE status = 'QUEUED' ORDER BY position ASC LIMIT 1 FOR UPDATE; It's …

mysql transactions rowlocking
sql server hint NOLOCK and ROWLOCK

I'm currently investigating an annoying problem on my website. We're giving away prizes regularly on the website, but to enter …

sql-server rowlocking
SQL Server ROWLOCK over a SELECT if not exists INSERT transaction

I have upgraded from SQL Server 2005 to 2008. I remember that in 2005, ROWLOCK simply did not work and I had to …

sql-server sql-server-2005 sql-server-2008 locking rowlocking
Row Level Locking in Mysql

I have 5 rows in a table (1 to 5). I want row 2 lock for some update and in the meanwhile if someone …

mysql innodb rowlocking
When exactly MySQL locks a row on updating InnoDB table?

If I have this multiupdate query UPDATE user u INNER JOIN user_profile up ON up.user_id = u.id …

mysql locking innodb rowlocking
Teradata - how to select without locking writers? (LOCKING ROW FOR ACCESS vs. LOCKING TABLE FOR ACCESS)

I am developing an application which fetches some data from a Teradata DWH. DWH developers told me to use LOCK …

teradata rowlocking table-locking
How do I lock on an InnoDB row that doesn't exist yet?

How can I guarantee that I can search if a username exists in my database, then insert that username into …

mysql locking innodb rowlocking database-locking