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

A Couple of Questions on Views

P: n/a
MG
Hi,

1) Can stored procedures be used against views?

2) What are the main limitation or disadvantages of using views?
Thanks,
mohsen
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
de*****@yahoo.com (MG) wrote in message news:<c8**************************@posting.google. com>...
1) Can stored procedures be used against views?
Yes
2) What are the main limitation or disadvantages of using views?


None, as long as you use common sense. For example, if you have a
view based on the dept table with lots of joins to other tables,
aggregate functions, calls to user-defined functions, etc. then it
would be inadvisable to use it in a query like "select dname from
my_view" if all you really needed was "select dname from dept".
Jul 19 '05 #2

P: n/a
MG
Thanks Andrew.

Mohsen
Jul 19 '05 #3

P: n/a
MG
Sorry, meant to write Tony :-)
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.