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
- 23894 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
Mention the different types of triggers?
What is the purpose of the tempdb database?
when you create a database how is it stored? : Sql server database administration
Define outer join in sql server joins?
How to execute the cursor queries with "open" statements?
What do we need queues in sql service broker?
What does <> symbol mean?
Explain what you mean by 3 tier architecture.
How to select an exiting database using mssql_select_db()?
Do you know what is normalization of database? What are its benefits?
What are different types of statements that are supported by sql?
Explain optimistic and pessimistic concurrency?
Why use sub query in sql server and list out types of sub queries?
How you can change the database name in SQL SERVER?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
