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

11y

950

1 Server Controls

How to apply lock on table.?

How to Lock perticular row from table?

Answers (2)

Forum Statistics

Please welcome our newest member Jenica .
2,381,650 users have contributed to 122,515 threads and 389,026
In the past 24 hours, we have 0 new threads, 0 new posts, and 0 new users.
In last week, the most popular thread is 'what is generative Engine optimization'.

Upcoming Events

View all

How Gen AI is Reshaping Content, Code, and Commerce

Our Training Programs

View all

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training