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
- 23832 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
How you provide security to cube? : sql server analysis services, ssas
What happens on checkpoint?
How to include text values in sql statements?
What number aggregate functions are accessible there in sql?
What are the different types of backups avaialabe in sql server 2005?
What is the maximum row of a size?
What are the different SQL Server Versions you have worked on?
How do you clear a log file?
Explain the collation?
explain extended properties
What is the difference between dbcc indexdefrag and dbcc reindex?
How do you run a trace?
What is attribute? : sql server analysis services, ssas
What is SubQuery in SQL Server 2008
Explain the difference between functions and stored procedures in sql server?
