Submitted Questions

  • May 28 2008
    09:02 AM
    49000
    42

    Difference between View and Stored Procedure
    • preetiv

    What is the difference between View and Stored Procedure? Can views accept input parameters as stored procedure? If yes,how could I do that? I am new to database and working on MS SQL,if someone could suggest me good reference websites then that would be great.

    Star Read Best Answer

    Editorial / Best Answer

    atdhdrolla  

    • Member Since Mar-2007 | Jul 16th, 2008

    View - A View in simple terms is a subset of a table. It can be used to retrieve data from the tables, Insert, Update or Delete from the tables. The Results of using View are not permanently  stored in the database.

    Stored Procedure -  A stored procedure is a group of SQL statements which can be stored into the database and can be shared over the netwrok with different users.

    Leena Roja

    • Jul 9th, 2015

    Views are virtual tables or subset of permanent tables for easier access of data which is stored in multiple tables. Views contains rows, columns just like a real table. The fields in a view are noth...

    Test

    • Oct 16th, 2013

    View does not have parameters , SP can have input / output parameters . View is another way to view table data . SP is pre-compiled object which can change /add data into tables.