Answer Posted / fam
a view can be thought as either a store query or a virtual table,store query coz in db only select statement is store and virtual table coz it perfilter the underlying table.
it is updatable in case of simple view and it is non updatable in the case of complex view.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can sub report data source be different from that of the parent report?
Would you store your query in a ssrs report or a database server? State the reason why?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
Can we insert data into a view?
what are the different types of SSRS reports?
What is checkpoint process in the sql server?
How do you implement session management in SQL Server mode?
What extended events?
How do I open port 1433?
What is read committed?
Why variables called the most powerful component of ssis?
How to modify existing triggers using "alter trigger"?
How you can get a list of all the table constraints in a database?
Can a unique index be created on a column, which contains null?
what's sql server? : Sql server database administration
