Difference B/W Triggers and Stored Procedurs?

[sonia.sardana]

Hey can anyone tell me whether Triggers and Stored Procedures are same?

Triggers are stored procedures that get executed automatically when an Insert,Update,o r Delete operation takes place.

Stored Procedures.------????

If i m right,Stored procedures are similar to Functions in C??

[Delerna]

you are correct.

I would add to stored procedures
that they execute on the server and they can, but don't have to, return a recordset like a view does.

other than that yes they are like functions and subs in programming languages such as c, vb, java etc.

[ck9663]

The only other difference is you can not embed a stored proc call in a statement, not like function

Correct:

If MyFunction() = 1

But Not:

If MyStoredProc = 1

-- CK