Interested to Buy Any Domain ? << Click Here >> for more details...
What is cursor ? And what is difference between Trigger ?
- 3 Answers
- 31676 Views
- HCL, Polaris, I also Faced
- E-Mail Answers
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 ddl command?
tell me the disaster recovery plan
How to convert a table data in XML format in sql server?
What is SQL Azure Federations?
Explain important index characteristics?
What do you think of this implementation? Can this be implemented better?
What is store procedure?
what exactly sql injuction.how to overcome.....
What is use of except clause? How it differs from not in clause?
What is the correct order of the logical query processing phases?
Can we use where and having clause together?
Explain about unique identifier data type in sql server?
What is sql injection? How to protect against sql injection attack?
Can sub report data source be different from that of the parent report?
 Explain what is sql override for a source taLle in a mapping?
