Interested to Buy Any Domain ? << Click Here >> for more details...
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
Which tcp/ip port does sql server run on? How can it be changed?
What is a print index?
What is the benefit of normalization?
How many clustered indexes there can be on table ?
Can two tables share the same primary key?
What are constraints?
What are the ways available in sql server to execute sql statements?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
Difference between Inner vs outer joins?
Explain throw statement in sql server 2008?
How do I view a trc file?
How many full-text indexes can a table have?
Explain use of expression builder.
Can we do dml on views?
What are built in functions?
