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
How to find the login name linked to a given user name?
When we should use @@error?
What is the difference between varchar and nvarchar datatypes?
What is the difference between upgrade and migration in sql server?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
How to convert numeric values to integers in ms sql server?
What happens when converting big values to numeric data types?
How can sql server instances be hidden? : sql server security
How would we use distinct statement? What is its use?
What is the recursive stored procedure in sql server?
What are the steps to follow to configure SQL*Net?
List out the differences between global and local temp tables in sql server?
How to test odbc dsn connection settings?
What are the lambda triggers?
Explain in brief about Microsoft SQL server?
