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 are recommended options to be used while using db mirroring? : sql server database administration
Explain what is use of dbcc commands?
What are distinctive joins find as a part of sql?
What is report server project?
Which tcl commands are available on the sql server?
When does a workload on SQL Azure get throttled?
What is a trigger in sql server?
Can an automatic recovery be initiated by a user?
What is bcp? When does it used?
Explain what is the difference between a local and a global temporary table?
mention different types of relationships in the dbms?
How do you trace the traffic hitting a sql server?
What is field in algebra?
Why people hate cursor?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
