Difference between Triggers and Stored Procedure

Answer Posted / ram

Stored Procedures are called by the programmer wherever it
wants to fire but triggers fired automatically when
insert,delete,update occured. And triggers can be
implemented to tables & views only where as s.p used in the
database independently

Is This Answer Correct ?    135 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1297


How do you delete a data source?

777


What is rtm version in sql server?

729


Where can you find the error log information? : sql server database administration

780


What is default port number for sql server 2000?

787


Explain what is sql server english query?

767


Write a program to fetch first 10 records from a file?

799


What are the results of running this script?

702


What is the use of floor function in sql server?

761


what is isolation level at dead lock?

1944


What's new in sql management studio for sql server? : sql server management studio

799


How would you add a section to a table?

795


How to find the source of a table in sql server?

729


Explain triggers in sql?

743


What are different types of constraints?

720