Difference between Stored Procedure and View in SQL Server.


Posted on March 21st, 2016 by Hitesh Kumar | 746 Views

Stored Procedure

  • Stored 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.

Related posts:

  1. What is the Difference between a Function and a Stored Procedure?
  2. What is a Stored Procedure?
  3. What is Execute Procedure WITH Result SETS in SQL Server?
  4. Contact Us

2 thoughts on “Difference between Stored Procedure and View in SQL Server.”

  1. PaulW

    Another key difference is the results of a view can be selected or joined, the resultset from a stored proc cannot.

  2. German

    Stored Procedure does data modification
    View cannot modify data and DML is forbidden when you define the view

Comments are closed.