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
Explain what is the use of custom fields in report?
What is the use of set nocount on/off statement?
what are cursors? : Sql server database administration
what is the main function of a query parameter?
How can you find out which stored procedures are recompiling?
Explain stored procedure?
what is the primary use of the model database? : Sql server administration
What are the fixed server level roles? : sql server security
What are the database roles? : sql server security
Explain syntax for dropping triggers?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What are types of storage modes? : sql server analysis services, ssas
What are the five major components of a dbms?
What happens if you delete a table that is used by a view?
can you implement data mining in SSRS?