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

Can two tables share a primary key?

950


how would you store your query in an SSRS report or a Database server?

152


Why do we use trigger?

916


What is field with example?

869


What is a matrix in ssrs?

135


What is an execution plan? How would you view the execution plan?

1013


how many layers of tcp/ip protocol combined of? : Sql server database administration

938


Is sql server a database?

924


What is the significance of master, tempdb and model databases?

1024


what is denormalization? : Sql server database administration

877


What is partition in sql server?

973


Explain isolation levels that sql server supports?

986


How to filter out duplications in the returning rows in ms sql server?

1067


What is a linked server in sql server?

1015


Explain SSRS Architecture?

183