WHAT IS DIFF B/W VIEWS AND STORED PROCEDURE
Answers were Sorted based on User's Feedback
Answer / ruchi
A view is a virtual table that consists of columns from one
or more tables. Though it is similar to a table, it is
stored in the database. It is a query stored as an object.
Hence, a view is an object that derives its data from one or
more tables. These tables are referred to as base or
underlying tables.
Once you have defined a view, you can reference it like any
other table in a database.
CREATE VIEW view_name
[(column_name[,column_name]….)]
[WITH ENCRYPTION]
AS select_statement [WITH CHECK OPTION]
Where:
A stored procedure is nothing more than prepared SQL code
that you save so you can reuse the code over and over again.
So if you think about a query that you write over and over
again, instead of having to write that query each time you
would save it as a stored procedure and then just call the
stored procedure to execute the SQL code that you saved as
part of the stored procedure.
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / asif aslam
In views we can access data with a page,not like session b/w
the pages.
Stored Procedure use for Database communication...
For Example: add,remove,update etc any record from database.
Is This Answer Correct ? | 3 Yes | 5 No |
What is ado.net code?
How many types of data table are in SQL.NET
4 Answers Chetu India, HCL, MAHINDRA,
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
What is a control toolbox?
What is the difference between connected and disconnected environment?
What is data view and variable view?
What happens when u try to update data in a dataset in .NET while the record is already deleted in SQL SERVER as backend?
In how many ways we can retrieve table records count? How to find the count of records in a dataset?
How to add a javaScript function in a datagrid?
What is different between sqlcommand object and command behavior object?
What is the meaning of executenonquery?
How does entity framework work?