Using NOLOCK in UPDATE statement

Question

Using NOLOCK in UPDATE statement:

Both the below queries are working fine.

UPDATE ml
SET CreationUserId = 'system'
FROM mst_login AS ml WITH (NOLOCK)
WHERE LoginId = 300


UPDATE mst_login
SET CreationUserId = 'system'
FROM mst_login WITH (NOLOCK)
WHERE LoginId = 300

What is the difference (in terms of performance) between these 2 ways of using NOLOCK in update statement?

score 5 · Accepted Answer · answered Oct 28 '13 at 20:49

5

There is no difference. One is just using a table alias.

answered Oct 28 '13 at 20:49

PRMan

535
1
8
16

Using NOLOCK in UPDATE statement

1 Answers1