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 is a serialized object?
What are the types of databinding?
What are the disadvantages of using datalist?
What is data view and variable view?
How will you fill the gridview by using datatable object at runtime?
What is ado.net object model?
Command objects uses, purposes and their methods.
Which is better ole db or odbc?
How to check if the Dataset has records ?
What is ado rdo dao in visual basic?
How can we serialize the dataset object?
Which method is used to sort the data in ADO.Net?
oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?
What are the rules to implement connection pooling?
Explain the dataadapter class in ado.net?