What will be working difference between the 2 Queries in SQL Server.
Type #1
update a
set a.authstatus = 'VALID'
from author a(nolock)
where a.author_name = @name
and a.dob = @dateofbirth
Type #2
update author
set authstatus = 'VALID'
from author
where author_name = @name
and dob = @dateofbirth
Can we use NoLock in the Update Statement. What is the significance for the use?