Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is a mutating table error and how can you get around it?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
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.
What are data files?
What is the security principal at the server level that represents your session?
When cursors are useful?
What is the difference between delete and truncate statements?
What is the difference between for auto and for nested?
Does partitioning improve performance sql server?
How to use linked server?
How does Report Builder support Analysis Services cubes?
what is difference between view and Dip.
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
Explain cross join or cartesian product in sql?
How to Check if table exists in sql server?
