Loading

difference between stored procedure and view's

ashok maram

9y875

difference between stored procedure and view's?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ravi Kiran Chanduri9y ago
Difference between SP and VW
http://www.dotnettricks.com/learn/sqlserver/difference-between-stored-procedure-and-function-in-sql-server
When to use SP and when to use VW
https://ask.sqlservercentral.com/questions/4788/when-to-use-view-and-stored-procedures-.html
0
Puneet Kankar9y ago
Stored ProcedureStored Procedure can have multiple select statement Stored Procedure can have parameters Stored Procedure exists in database Stored procedure return predefined result. View View can have only one select statement View does not have any parameter View are virtual and does not exists in database Views can return different result based on where condition.
+1