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 the purpose of grouping data in a report?
What are wait types?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What is sql server transaction log file?
Explain what are the different index configurations a table can have?
What is resource governor?
What is query optimization process?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
Which is better statement or preparedstatement?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
Do you know how to implement service broker?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
What is reportserver and reportservertempdb ?
How do you open a cluster administrator?
