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
Can two tables share a primary key?
how would you store your query in an SSRS report or a Database server?
Why do we use trigger?
What is field with example?
What is a matrix in ssrs?
What is an execution plan? How would you view the execution plan?
how many layers of tcp/ip protocol combined of? : Sql server database administration
Is sql server a database?
What is the significance of master, tempdb and model databases?
what is denormalization? : Sql server database administration
What is partition in sql server?
Explain isolation levels that sql server supports?
How to filter out duplications in the returning rows in ms sql server?
What is a linked server in sql server?
Explain SSRS Architecture?