Interested to Buy Any Domain ? << Click Here >> for more details...
1.what is the difference between view and cursor?
2.If we do any change in view will it affect the
database,similarly when we do changes in cursor will it
affect the databse?with certain example?Thanks
- 5 Answers
- 23676 Views
- I also Faced
- E-Mail Answers
Answer Posted / avinash
Change in view would not reflect chg in db but in cursor it
would.
| Is This Answer Correct ? | 5 Yes | 32 No |
Post New Answer View All Answers
What is the default order of an order by clause?
What are the differences between lost updates and uncommitted dependencies?
How do I start sql server 2016?
Explain what is scheduled job and how to create it?
What are the differences between stored procedure and view in sql server?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
What is conditional split?
What is transactional replication?
What does man by sql wildcard characters in sql server?
What are locks in sql?
Difference between drill down and drill through report.
What are difference between Cluster index and Non-Cluster index?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
How many types of attribute relationships are there? : sql server analysis services, ssas
What the different components in replication and what is their use?
