What is cursor ? And what is difference between Trigger ?
Answer Posted / sanjay kumar dinda
Cursor is a database object used by applications to
manipulate data in a set on a row-by-row basis, instead of
the typical SQL commands that operate on all the rows in
the set at one time.
Trigger is a database object invoked automatically when any
event occured.
These aevents are
Delete, Insert, Update etc....
SQL server store the intermediate data into to dummy table
INSERTED and DELETED...
At the time of insert operation SQL Server STores inserted
rows into the INSERTED table and at the time of delete or
update SQL Server stores the information into DELETED dummy
table
Is This Answer Correct ? | 19 Yes | 7 No |
Post New Answer View All Answers
What gets stored inside msdb database?
What do you understand by coalesce in sql server?
Explain hostprotectionattribute in sql server 2005?
How to rebuild the master database?
What are the diifferences between the ms sql server vs mysql?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
What is lookup override?
what is a self join? Explain it with an example? : Sql server database administration
What is optimistic concurrency?
What is tabulation?
What is the temp table?
What are the difference between primary keys and foreign keys?
What is raid? : SQL Server Architecture
What is scheduled job and how to create it?
What are the advantages of passing name-value pairs as parameters?