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
- 22333 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 difference between materialized view and view?
How to execute multiple stored procedures at one time in sql server?
What are the fixed server level roles? : sql server security
What is the data type of time?
Will sql server 2005 allow you to reduce the size of a column?
How to list all field names in the result set using mssql_field_name()?
Can a table be created inside a trigger?
Explain how to integrate the ssrs reports in application?
What is transaction server isolation?
How to see the event list of an existing trigger using sys.trigger_events?
What are the limitations/drawbacks or ssrs 2008 r2?
How to execute the cursor queries with "open" statements?
Can we return Data from 4(more than 1) tables in stored procedure?
Explain query editor regions
Can you name a few encryption mechanisms in sql server?
