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 Reporting Life Cycle?
Name 3 ways to get an accurate count of the number of records in a table?
What happens if ntwdblib.dll is missing on your machine?
How can we delete a table in sql server?
What is intellisense?
How to list all stored procedures in the current database using ms sql server?
What are the differences between DDL, DML and DCL in SQL?
What are the export options of ssrs?
What do you know about system database? : SQL Server Architecture
How do I view a trc file?
Benefits of Stored Procedures?
What is the need for indexing?
What is the full meaning of dml?
Explain what is use of dbcc commands?
What is the boxing and unboxing concept in .net?