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
Describe in brief authentication modes in sql server.
Is it true, that there is no difference between a rule and a check constraint?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
Write a SQL queries on Self Join and Inner Join.
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
What is the default Port No on which SQL Server listens?
How to create prepared statements using odbc_prepare()?
What is the use of sign function?
what is a live lock? : Sql server database administration
What is RAID? What are the different types of RAID configurations?
What will be the maximum number of indexes per table?
You want to implement the many-to-many relationship while designing tables. How would you do it?
Comment,Datatypes are unlimited
Explain active/passive and active/active cluster configurations?
What is difference between rownum and rowid?
