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
- 23696 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
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
Explain full-text query in sql server?
How do I find the sql server version?
What does normalization do to data?
What is the difference between a check constraint and a rule?
What is normalization according to you and explain its different levels?
What is the difference between a clustered index and a non-clustered index?
How many ways to create table-valued functions?
What are joins in sql and what are the different types of joins?
What do you mean by subquery?
What is Command line parameters in PLSQL.?
Explain the properties of subqueries in sql server?
Tell me when is the update_statistics command used?
How many levels of sp nesting is possible?
What triggers long term care?
