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
Answers were Sorted based on User's Feedback
Answer / shaik
There is no affect in DB while changing in both casess.
Is This Answer Correct ? | 21 Yes | 5 No |
Answer / 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 |
Answer / bindu
Both Cursors and Views doesn't store data , so their is no chance to affect the DB.
Is This Answer Correct ? | 4 Yes | 5 No |
Answer / avinash
Change in view would not reflect chg in db but in cursor it
would.
Is This Answer Correct ? | 5 Yes | 32 No |
how to determine the service pack currently installed on sql server? : Sql server database administration
Explain full-text indexing?
Do you know what is a with(nolock)?
explain different types of jions with examples briefly?
1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?
How to create nested stored procedure?
select name of emplyoee whose total salary is 130 from following table. id name salary 1 a 100 2 b 20 3 c 50 1 a 30 2 b 70 Post the resulantant Query?
Explain foreign key in sql server?
What is the difference between for auto and for nested?
Is mysql better than sql server?
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
What is transaction server explicit transaction?