|
A custom view is a "virtual" table created from a predefined query, so is a filter on preset parameters. They are used more for security aspects as the end user is working on a "virtual" dataset rather than on the live database.
A stored procedure is much more powerful and is normally used for automating a group of functions or running queries where different parameters may be needed for the data extraction.
These are basic explanations, there is obviously much more to both.
If your filter is based on static parameters and is always going to be the same then use a view.
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
|
