Do views refresh if you reference them in a subquery?

Question

I created a view in SQL Server 2008. It is the result set from joining two tables.

I am now running a query on another table that will have the following filter:

WHERE column_a NOT IN 
     (
     SELECT column_b
     FROM my_view
     )

Will this automatically regenerate the view so that column_b is up to date?

Answer 1

Yes, views are living things, with feelings too! :)