Articles → SQL SERVER → Difference Between Views And Stored Procedure In SQL Server

Difference Between Views And Stored Procedure In SQL Server



Stored ProcedureViews
A stored procedure accepts parametersA view does not accept parameters
A stored procedure is not preferred as the building block for larger queriesA view is preferred as a building block for larger query
A stored procedure can contain multiple statements like loops, if-else, etc.A view can contain only one single select statement
A stored procedure can perform modifications to one or more tablesA view cannot perform modifications to any table



Posted By  -  Karan Gupta
 
Posted On  -  Tuesday, November 28, 2017

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250