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
What does datareader object do?
Explain all the classes those are used for database connections between sql server and asp.net?
Explain the dataadapter class in ado.net?
What is linq and entity framework?
Why is it important to close an ado.net application?
What are the 3 major types of connection objects in ado.net?
What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?
What are the uses of Stored Procedure?
Is bulk insert faster than insert?
What are ado.net objects?
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?
How can you add or remove rows from the datatable object of dataset?
What is serialization and de-serialization in .net? How can we serialize the dataset object?
What is datatable in ado.net?
