Interested to Buy Any Domain ? << Click Here >> for more details...
What is cursor ? And what is difference between Trigger ?
- 3 Answers
- 31831 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
How to drop an existing schema in ms sql server?
How to run sql server 2005 books online on your local system?
Difference between report and query parameter. Why do we need different type of parameter?
How would we use distinct statement? What is its use?
Is oracle faster than sql server?
What is the difference between a primary key and a unique key? Are they the same?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
How many partitions a clustered index has by default in sql server 2012?
Explain what are the restrictions while creating batches in sql server?
Explain how to send email from sql database?
How to optimize stored procedures in sql server?
What is the usage of sign function?
Define full outer join?
What are the recovery models in sql server 2000?
Can you always create a cache of a report?
