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
Does the unique constraint create an index?
Explain cdc and sql injection?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
How to change the data type of an existing column with "alter table" statements in ms sql server?
What is a data collection table?
What is nonclustered index with included columns ?
What is the difference between osql and query analyzer?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
What is the latest version of microsoft sql server?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
How to edit table in sql server 2017?
How to list all login names on the ms sql server?
What is the template in sql?
What is a view and what are its advantages?
What is sql server 2000 work load governor?