Difference between view and stored procedure in Sql Server

Here is a good summary:

A Stored Procedure:

accepts parameters

can NOT be used as building block in a larger query

can contain several statements, loops, IF ELSE, etc.

can perform modifications to one or several tables

can NOT be used as the target of an INSERT, UPDATE or DELETE statement.

A View:

does NOT accept parameters

can be used as building block in a larger query

can contain only one single SELECT query

can NOT perform modifications to any table

but can (sometimes) be used as the target of an INSERT, UPDATE or DELETE statement.

View is a Virtual Table representation using SELECT query only. Store Procedure is like a method to write database related business logic using combination of SELECT, UPDATE, INSERT, DELETE queries and different user-defined anf system defined functions.

 

Mark the answers as accepted if helpful.

For more visit: www.asmak9.com