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 is the datatype of rowid?
Explain in details security in SQL azure?
Explain rdbms?
How to read data in a table with "select" statements?
Explain log shipping and mention its advantages.
What is table valued function and scalar valued functions?
What is enhanced database mirroring in sql server 2008?
What are the parts of a function?
What is the data type of time?
Can one drop a column from a table?
What is similarity and difference between truncate and delete in sql?
What is difference between standardization and normalization?
What do you mean by normalisation?
How do users use Report Builder with SQL Server data sources?
Tell me what is use of except clause? How it differs from not in clause?