Row Lock On Update Statement

#1

What is the correct syntax to create a row lock for an update statement that
updates only a single row in a table? This should help performance since it
does not have to lock the table to update a single row.

Thank You,

#2

You don't place lock on it, SQL Server will and it won't lock the table for
it.

"Joe K." <Joe K. (AT) discussions (DOT) microsoft.com> wrote

Quote:

What is the correct syntax to create a row lock for an update statement
that
updates only a single row in a table? This should help performance since
it
does not have to lock the table to update a single row.

Thank You,

#3

If your update's WHERE clause uses a key, you should not see the entire
table getting locked. Is that what you're seeing?

--
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--

"Joe K." <Joe K. (AT) discussions (DOT) microsoft.com> wrote

Quote:

What is the correct syntax to create a row lock for an update statement
that
updates only a single row in a table? This should help performance since
it
does not have to lock the table to update a single row.

Thank You,

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Row Lock On Update Statement

microsoft.public.sqlserver.server microsoft.public.sqlserver.server

Row Lock On Update Statement - 12-02-2005 , 12:47 PM

Re: Row Lock On Update Statement - 12-02-2005 , 01:14 PM

Re: Row Lock On Update Statement - 12-02-2005 , 02:55 PM