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
What is dbcc command in sql server?
How to count rows with the count(*) function in ms sql server?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
How to create an index on an existing table in ms sql server?
Explain where clause?
What is the difference between char and varchar2 datatype in sql?
What is the difference between an index and a unique index?
What is default constraint?
What is difference between materialized view and view?
How to modify the underlying query of an existing view?
What are the benefits and tasks of object explorer? : sql server management studio
What are the difference between primary key and unique key? : sql server database administration
What are the export options of ssrs?
How to enter binary string literals in ms sql server?
What is difference between joins and subqueries?