whats is the difference between cursors and triggers? give clear example with code..

Question

1.50/5 (5 votes)

See more:

SQL-Server-2005

SQL-Server

I trying to find the diff between cursors and triggers.

Posted 21-Jun-11 22:39pm

CS1401

Add a Solution

Comments

Sergey Alexandrovich Kryukov 22-Jun-11 14:00pm

"What's the difference between Apple and apple?", "What's the difference between a horse and a saddle?" do you feel the absurd or you need more?
This is not a question. Ask what do you need to know on each...
--SA

3 solutions

Solution 3

curser is an database object and retrive the rows from database row by row.

trigger it's also database object and you can perform an action trigger will fire automatacally.

Posted 3-Jun-13 1:06am

Nikul Khandla

Comments

CHill60 3-Jun-13 7:08am

Please do not resurrect old questions that have already been answered

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Accepted Answer · 2011-06-21T22:44:00

Solution 1

Cursors [^]versus Triggers[^] - they are different constructs and cannot be compared or contrasted directly.

Posted 21-Jun-11 22:44pm

Abhinav S

Comments

Sergey Alexandrovich Kryukov 22-Jun-11 14:00pm

My 5. I don't know how to tell it to everyone; please see my comment to the question above.
--SA

Abhinav S 22-Jun-11 14:11pm

Thanks for the 5.
That is exactly how I wanted to put it - apples and oranges!

Prerak Patel · Accepted Answer · 2011-06-21T22:44:00

Solution 2

Cursors allow row-by-row prcessing of the resultsets.
Triggers are special kind of stored procedures that get executed automatically when an INSERT, UPDATE or DELETE operation takes place on a table.

More information: Cursor[^] | Trigger[^]

Posted 21-Jun-11 22:44pm

Prerak Patel

Comments

CS1401 22-Jun-11 9:04am

Thanks for your interest patel.

Prerak Patel 22-Jun-11 9:06am

You are welcome.