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 sql server 2016 have ssms?
What are the Advantages of using CTE in sql server?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
How can I create a new template for import ? : sql server management studio
What is SQL Azure Federations?
How to delete duplicate rows from table except one?
Explain go command in sql server?
How to view the error log for any specific instance? : sql server database administration
Write a SQL query in order to merge two different columns into single column?
Describe in brief system database.
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
How efficient you are in oracle and SQL server?
What number sorts of privileges are accessible in sql?
What is sql language?
What is temporal table?