Will the locked row will be listed in select query

Question

0.00/5 (No votes)

See more:

I have used the code below

SQL

BEGIN TRAN

SELECT *
FROM authors
WITH (HOLDLOCK, ROWLOCK)
WHERE au_id = '123'

when any other user uses

SQL

SELECT *
FROM authors

will the record with id 123 will be listed or not

Posted 12-Jun-14 19:35pm

Comments

Magic Wonder 13-Jun-14 1:42am

Have you tried the same?

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Magic Wonder · Answer 1 · 2014-06-12T19:49:00

You can try the same at your end also.

Anyway, Yes it will be listed.

Posted 12-Jun-14 19:49pm