I am confused about a few points:
-
What is the difference between a stored procedure and a view?
-
When should I use stored procedures, and when should I use views, in SQL Server?
-
Do views allow the creation of dynamic queries where we can pass parameters?
-
Which one is the fastest, and on what basis is one faster than the other?
-
Do views or stored procedures allocate memory permanently?
-
What does it mean if someone says that views create a virtual table, while procedures create a materials table?
Please let me know about more points, if there are any.