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
- 23850 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
What is inline variable assignment?
What are constraints in microsoft sql server?
What is key set driven?
List all the types of user-defined functions?
How to execute a stored procedure in ms sql server?
what is sql server? : Sql server database administration
What is the difference between update lock and exclusive lock?
What is difference between views and stored procedures?
What are user-defined functions (udfs) in sql server?
Define views.
What is the stuff and how does it differ from the replace function?
Explain aggregate functions?
Can foreign key be deleted?
How to create function with parameter in sql server?
How to rename an existing column with sql server management studio?
