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
Why is it important to close an ado.net application?
Which object holds only data and does not interact with data source?
What we do with the object of ado.net dataset after using it?
What is ado object model?
What is the difference between oledb sql server and oledbdotnet provider?
What is ado.net tutorial?
how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?
Explain the role of data provider in ado.net? What is the role of data provider in ado.net?
What are the connected and disconnected modes in ado.net?
Explain the difference in record set and dataset?
What is the difference between executenonquery () and executescalar ()?
Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?
What is the use of connection object in ado.net?
What are the benefits of ADO.NET?
What is ado.net components?
