What is a view? is View updatable?

Answer Posted / vikash kr pandey

view is a virtual table , which provides to a subset of columns from one or more tables. in which doesn't have its own data.
yes view is updatbable in a single update statement

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain activity monitors

625


How to find the version of sql server? : sql server database administration

630


What is the difference between lock, block and deadlock? : sql server database administration

566


What are out-of-range errors with date and time literals?

556


What are the system database in sql server 2008?

576






How to join two tables in a single query in ms sql server?

542


What is collation sensitivity? Explain different types.

549


When I run the sql server 2000 setup, it just hangs. What do I do?

654


What is sql server management studio? : sql server management studio

586


what method you can use to reduce the overhead of Reporting Services data sources?

151


How you trouble shoot when any job fails

1506


How can we delete a table in sql server?

554


List the different types of collation sensitivities in sql server?

528


Explain what is the purpose of sql profiler in sql server?

554


How to add additional conditions in SQL?

590