Interested to Buy Any Domain ? << Click Here >> for more details...
What is cursor ? And what is difference between Trigger ?
- 3 Answers
- 31494 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 resource db in sql server?
What do you understand by the denormalisation?
What do you mean by an execution plan? Why is it used?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
How to get the number of affected rows?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
What is the return type of executeupdate ()?
what is a mixed extent? : Sql server administration
What triggers long term care?
In which sql server version report builder introduced?
Is it possible to have clustered index on separate drive from original table location?
How fixed length strings are truncated and padded?
Differentiate between ms sql server reporting services vs crystal reports?
How to get a list of all tables with "sys.tables" view in ms sql server?
What is data source in connection string?
