Answer Posted / waseem
a view is a virtual table based on the result-set of an SQL
statement.
The fields in a view are fields from one or more real tables
in the database.
You can add SQL functions, WHERE, and JOIN statements to a
view and present the data as if the data were coming from
one single table.
A view always shows up-to-date data! The database engine
recreates the data, using the view's SQL statement, every
time a user queries a view.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is scheduled job and how to create it?
What is the process of normalization?
What is triggers and its types?
what is the primary use of the model database? : Sql server administration
How can I create a new template for import ? : sql server management studio
Explain rdbms?
Can truncate be rolled back?
What is user defined datatypes and when you should go for them?
Define model database?
what is a traditional network library for sql servers? : Sql server database administration
Write a SQL command to insert and update only a particular field?
Is INSTEAD OF trigger directly applicable to Table ?
What stored by the msdb?
How can we solve concurrency problems?
can we have a nested transaction? : Sql server database administration