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 |
Differences between dataset.clone and dataset.copy?
What is connection string?
What is aggregating data ?
What is the functionality of data provider in ado.net?
What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?
What is datasource in ado.net?
What are the advantages and disadvantages of using datalist?
What is a serialized object?
Can we bind one datareader wid two dropdown list?
What are dataproviders?
Which object needs to be closed?
What is the Magic Tables in Sqlserver2000?