By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,574 Members | 1,968 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,574 IT Pros & Developers. It's quick & easy.

Views in SQL server

100+
P: 147
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
Apr 29 '09 #1
Share this Question
Share on Google+
2 Replies


ck9663
Expert 2.5K+
P: 2,878
A view always execute against the table.So once you update the table, run your view and it will return the updated data.


--- CK
Apr 29 '09 #2

100+
P: 147
Thank you ck9663

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

Thanks
Apr 29 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.