PART-14 | Appian Interview Question |What is the difference between a stored procedure and a view?

1) What is the difference between a stored procedure and a view?

A Stored Procedure:

1) Accepts parameters
2) Can NOT be used as building block in a larger query
3) Can contain several statements, loops, IF ELSE, etc.
4) Can perform modifications to one or several tables
5) Can NOT be used as the target of an INSERT, UPDATE or DELETE statement.

A View:

1) Does NOT accept parameters
2) Can be used as building block in a larger query
3) Can contain only one single SELECT query
4) Can NOT perform modifications to any table
5) But can (sometimes) be used as the target of an INSERT, UPDATE or DELETE statement.