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 the security model used in sql server 2005?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
Can we call stored procedure in view in sql server?
How to use “drop” keyword in sql server and give an example?
What is the difference between push and pull subscription? : sql server replication
What is the fastest way to permanently delete a 1 million row table named customers?
How do we synchronize On-Premise SQL server with SQL Azure?
What is difference between index seek vs. Index scan?
What is the downside of using udf?
what is a live lock? : Sql server database administration
What is a file group?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
what is an index? : Sql server database administration
What is trigger explain with program?
Can we hide the definition of a stored procedure from a use?