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
Explain intellisense for query editing
Write query to return all rows sql?
What is transaction server auto commit?
Do you know clustered and non-clustered index?
How will you find out if there are expensive SQL statements running or not?
What sql server means?
Explain in details security in SQL azure?
What are the built in functions in sql server?
How to apply cascading referential integrity in place of triggers?
Explain the advantages of merge replication?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
What are translations and its use? : sql server analysis services, ssas
what are isolation levels? : Sql server database administration
What do mean by xml datatype?
How can sql injection be stopped? : sql server security