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
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 can move data or databases between servers and databases in sql server?
What are examples of triggers?
How do you set a trace flag in sql server?
Tell about MOM Tool(Microsoft Operator Manager)?
Is null vs coalesce?
How many types of database relationship in sql server?
What are the different types of subquery?
what is a join and explain different types of joins? : Sql server database administration
What is abstracting periodical?
Does windows server 2016 come with sql server?
What is BCNF? How is it better than 2NF & 3NF?
What is b tree index?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
Explain unique key in sql server?
What is temporary table in sql server? Why we use temp table?