Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is a view? is View updatable?

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


Please Help Members By Posting Answers For Below Questions

Explain intellisense for query editing

1029


Write query to return all rows sql?

1054


What is transaction server auto commit?

1061


Do you know clustered and non-clustered index?

979


How will you find out if there are expensive SQL statements running or not?

1015


What sql server means?

967


Explain in details security in SQL azure?

121


What are the built in functions in sql server?

985


How to apply cascading referential integrity in place of triggers?

1034


Explain the advantages of merge replication?

952


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?

1107


What are translations and its use? : sql server analysis services, ssas

1040


what are isolation levels? : Sql server database administration

993


What do mean by xml datatype?

1103


How can sql injection be stopped? : sql server security

1036