Difference Between Stored Procedure and Functions Sql

Stored Procedure and Functions   1. Function Must Return Value    For Stored Procedure it's Not Must to return value it's optional  2. Stored Procedures are pre-compile objects which are compiled for  first time and its compiled format is saved which executes (compiled code) whenever it is called  But Function is compiled and executed...

Difference Between Views And StoredProcedure Sql

Stored Procedure Vs Views 1. Stored Procedure are collection of pre-executed sql Statements that accepts parameters as input and depending on input parameters passed gives the Output Result Views Act like Virtual Tables That Contains set of Rows and Columns from multiple original table of Database according to defined Query Commands 2. Stored Procedure Cannot be Used as...