NOLOCK Applicable to All Tables
-
if i apply a NOLOCK on one table in a Stored Procedure then will it be applicable to all other tables consumed in that Stored Procedure too automatically - Happy Coding - Vishal Vashishta
-
if i apply a NOLOCK on one table in a Stored Procedure then will it be applicable to all other tables consumed in that Stored Procedure too automatically - Happy Coding - Vishal Vashishta
No.
-
No.
Ok ... but can you make me clear little bit more about the NOLOCK concept,any article you want to refer.? - Happy Coding - Vishal Vashishta
-
if i apply a NOLOCK on one table in a Stored Procedure then will it be applicable to all other tables consumed in that Stored Procedure too automatically - Happy Coding - Vishal Vashishta
Sorry to take so long to get back with you but I was on vacation. Take a look at:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED --avoids deadlock
Since NOLOCK is a 'hint' it is only for the one command.