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
- 23884 Views
- I also Faced
- E-Mail Answers
Answer Posted / sripathi venkata ramesh
I am Sripathi Venkata Ramesh from Gudivada.
1. The answer for view and cursor is mentioned below
Views: Views are used to retrieve date or Update the data
Cursors: Cursors are used to execute the data row by row or
record by record.
There are 2 types of cursors.
1. Implicit cursor: It returns only one
row
2. Explicit cursor: It returns more
than one row
| Is This Answer Correct ? | 19 Yes | 7 No |
Post New Answer View All Answers
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
What is it unwise to create wide clustered index keys?
What is transaction server auto commit?
What do you understand by user-defined function in the sql server?
Can binary strings be used in arithmetical operations?
What is the difference between grant and with grant while giving permissions to the user?
What is ems sql management studio? : sql server management studio
How to Sync Two SQL Azure Databases?
How do you test your database? : sql server database administration
What command is used to create a database in the sql server and how?
What is difference between table aliases and column aliases? Do they affect performance?
List the ways in which dynamic sql can be executed?
What are synonyms?
What is clr ddl trigger?
Define a cross join?
