Views in SQL server

[DaveRook]

Hi

I am new to SQL server!

I use the 'views' to show my data on a website so I have some level of protection if any one were to do something malicious!

However, is there a way to automatically update it?

On my server, I have the table and a view. What I would like to do is update the table which automatically updates the view! Is there a way of doing this or do I have to re-create the view each time I update the table!

I am using SQL express 2008 (free version)!

Thanks

Dave

[ck9663]

A view always execute against the table.So once you update the table, run your view and it will return the updated data.


--- CK

[DaveRook]

Thank you

Thank you ck9663

I went into the design view of the view, ran the query and it worked.

Thanks