Showing posts with label Views Vs Stored Procedure. Show all posts
Showing posts with label Views Vs Stored Procedure. Show all posts

Thursday, 20 August 2015

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