View with no lock

[baran121]

Hi everybody,
I have a view name view_verim_hesap
Has tables that i didnt uze with (nolock)
So if i put with (nolock) to tables in the views
Do i need to use with (nolock) also for view
Select * from view_verim_hesap with (nolock)

 

[jbenson001]

It seems you don't
Check out this forum post and answers:

http://stackoverflow.com/questions/...query-using-view-does-it-propagate-within-the

 

[baran121]

actually i already search on google and tek-tips.
but couldnt see this web site on google.
It is exactly what i asked.thank you very much.

 

[jbenson001]

you're welcome