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
- 23901 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 optimization and its types?
What is sql server transaction log file?
What is the syntax to execute the sys.dm_db_missing_index_details?
Where sql server usernames and passwords are stored in a sql server?
what are the core components of SSRS?
What is the purpose of a table?
what is normalization? : Sql server database administration
Can a unique index be created on a column, which contains null?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
Can we insert data into view sql server?
What is a database in ms sql server?
How to create user defined functions with parameters?
What is change data capture (cdc) in sql server 2008?
Why should you use or avoid select * statements?
How to list all objects in a given schema?
