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
What is user-defined inline table-valued function?
Can a unique index be created on a column, which contains null?
How to start and end transact-sql statements?
What are the default system databases in sql server 2000?
Why do we use functions?
What is an execution plan? How would you view the execution plan?
How is a full-text index updated?
Explain time data type in sal server 2008?
What is query parameter in ssrs?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
Explain the steps to use transact-sql cursor?
How do I schedule a sql server profiler trace?
What is data source object?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
