Answer Posted / ashok
1.If we create a table it will save in database but a view is a virtual image there is no physical existance.
2. We can use order by clause in tables but views does not support order by clause.
3.In a view we can specify only a select statement inside a view but in tables we use all dml,ddl statements.
4.If we updating a base table using view which contains joins may not update correctly,but in tables we can update using joins.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain alternate key, candidate key and composite key in sql server?
what are the disadvantages of cursors? : Sql server database administration
How to change a login name in ms sql server?
What is self contained scalar sub query?
How to create function with parameter in sql server?
what is raid? : Sql server database administration
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
What is postgresql server?
what are different types of backups available in sql server? : Sql server database administration
What are the types of indexes?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
Explain log shipping and mention its advantages.
List the different types of joins?
How do we know if any query is retrieving a large amount of data or very little data?
What is ms sql server triggers?
