If you include a NOLOCK hint on a select from a VIEW, does that NOLOCK hint propagate down into the tables joined within the view? If not, what's the purpose of locking a view?
Sample view code:
CREATE VIEW [my_custom_view]
AS
SELECT
a1.[column_a], a1.[column_b], a1.[column_c], a1.[column_d]
FROM
[table_a] a1
JOIN [table_b] b1 ON b1.[column_a] = a1.[column_b]
And the NOLOCK statement:
SELECT
[column_a], [column_b]
FROM
[my_custom_view] NOLOCK
