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
How do I get to sql server configuration manager?
What is oltp (online transaction processing)?
What is a field name?
Can a table have 2 foreign keys?
What is the purpose of sql profiler in sql server?
Explain the Ways to improve the performance of a sql azure database?
Is there any difference between the primary key and unique key?
Explain why variables called the most powerful component of ssis?
define and explain the differences between clustered and non-clustered indexes.
whats the maximum size of view state??
What is table-valued sub query?
What do you understand by a stored procedure?
What is forward - only cursors / read only cursor?
What are the database roles? : sql server security
How to execute the cursor queries with "open" statements?
