A Couple of Questions on Views

[MG]

Hi,

1) Can stored procedures be used against views?

2) What are the main limitation or disadvantages of using views?
Thanks,
mohsen

[Tony]

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".

[MG]

Thanks Andrew.

Mohsen

[MG]

Sorry, meant to write Tony :-)