How to apply lock on table.? or How to Lock perticular row from table?

BEGIN TRAN SELECT * FROM authors WITH (HOLDLOCK, ROWLOCK) WHERE au_id = 142 /* Do all your stuff here while the record is locked */ COMMIT TRAN Note: The HOLDLOCK hint will instruct SQL Server to hold the lock until you commit the transaction. The ROWLOCK hint will lock only this record and not issue a page or table lock.

Apply Row lock as below UPDATE Employees WITH (HOLDLOCK,ROWLOCK) SET Salary=454545 WHERE Id=3 COMMIT TRAN Check below urls for more detail http://technet.microsoft.com/en-us/library/ms378471(v=sql.110).aspx http://www.sqlteam.com/article/row-locking

Answers

How to apply Lock on sql table?

Avinash Aher

10y

1.3k

How to apply lock on table.?

How to Lock perticular row from table?

Answers (2)

Next Recommended Forum

same ID different rows in sql

Sql Query or .net code

Forum Statistics

Please welcome our newest member Geo Green.
3,089,804 users have contributed to 147,411 threads and 483,553
In the past 24 hours, we have 9 new threads, 18 new posts, and 231 new users.
In last week, the most popular thread is 'what are libraries are there in python for Schedule'.

Upcoming Events

View all

Get Web3 Ready: Dive into Blockchain with C# Corner
Vibe Coding Bootcamp
Software Architecture Conference - 2025