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
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
What is a recursive stored procedure in sql server?
What is blocking?
What is bcp? When does it used?
What are types of storage modes? : sql server analysis services, ssas
What stored by the master? : sql server database administration
What is the contrast between sql and pl/sql?
What does executeupdate return?
How can windows applications connect to sql servers via odbc?
What are the different types of sql server replication? : sql server replication
How check triggers in sql server?
Do you know spatial data types - geometry and geography in sql server 2008?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What is use of dbcc commands?
