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
- 22331 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 sql server instance name?
What is a field name?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
What is the difference between count () and rowcount ()?
What is user-defined functions? What are the types of user-defined functions that can be created?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
What are SSL and TSL protocols?
Why use view instead of a table?
what type of index will get created after executing the above statement? : Sql server database administration
How is foreign key related to primary key?
What is right outer join in sql server joins?
What are the types of indexing?
How can we check the sql server version?
Explain syntax for dropping triggers?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
