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
Explian About DataAdapters
What is ado and dao?
What are the advantages of oledb compared with other classes?
Define the executescalar method?
What do you mean by ‘batch updates’?
What is Data Provider?
What are dataproviders?
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
What are the rules to implement connection pooling?
What are datareaders?
What are the key events of sqlconnection class?
how to create a quiz software using 4 options to answer and how to check with answers in the database and award marks....
What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?
how we can fire event in databound coulm in datagfrid withot using button?
What are all the different methods under sqlcommand?