Answer Posted / subhash chandra
views snapsot of multiple table into one one vertual table.
views can be update,insert,delete,its effect base tables
depend upon..
if you update/insert when- base table is multiples/sigle
respectively
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
What are subquery and its properties?
Why use “in” clause in sql server?
Mention a few common trace flags used with sql server?
What is the fillfactor concept in indexes?
What are the operating modes in which database mirroring runs?
What is the datatype of rowid?
What is inner join in sql server joins?
What is the difference between composite index and covering index?
Why de-normalization required?
Explain difference between cross join and full outer join?
What is the difference between a primary key and a unique key? Are they the same?
Is mysql better than sql server?
Can we call future method from trigger?
Explain syntax for viewing, dropping and disabling triggers?