Interested to Buy Any Domain ? << Click Here >> for more details...
What is cursor ? And what is difference between Trigger ?
- 3 Answers
- 31649 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
Explain query editor regions
Do you know what are the differences between lost updates and uncommitted dependencies?
How to rebuild all indexes on a single table?
What are system databases into sql server (2005/2008) : sql server database administration
Can you please differentiate between a primary key and a unique key?
what are constraints? : Sql server database administration
What is triggers and its types?
What is the report builder?
Can a database be shrunk to 0 bytes, if not, why?
What is the advantage of sql server?
Can I save my report as html, excel or word? : sql server management studio
How to use go command in "sqlcmd"?
If the job running very slow what is the action you do
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
How to execute function in stored procedure sql server?
