Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
How to Read, Add, Update and Delete record in Entity Framework ?
What is the role of clr?
What is ado in agriculture?
Which property is used to check whether a DataReader is closed or opened?
What is the difference between executenonquery () and executescalar ()?
Which namespaces are used for data access?
How to create data relations?
Describe ado.net object model in detail.
Explain the advantage of ADO.Net?
Give an example of a .net application which connects to microsoft access database using ado.net classes.
What is sql command in ado net?
What is Dataset Object?
What is the difference between dataset and datatable?
Explain ado.net features?
What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
