Difference between Triggers and Stored Procedure

Answer Posted / madhu prakash p

sp and trigger are both predefined set of sql statements

we can pass the arguments for sp but we cant pass the
arguments for triggers.

trigger will fire implicitly, when ever relavent action
performed by the user on the tables where the triggers are
placed.

But in the stored procedures u must call explicitly.

Is This Answer Correct ?    43 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why we use the openxml clause?

794


How do you delete duplicate records in sql server?

783


What is meant by dirty read?

812


Can you import Microsoft Excel data to SSRS?

111


What is scheduled job and how to create it?

771


What are various ways to enhance the ssrs report?

775


what is the difference between Tabular and Matrix report?

146


What is the sql case statement used for?

807


How can you start sql server in different modes?

769


How to list all dsn entries on your local machine using odbc_data_source()?

798


How to update muliple row in single query?

848


What is 2nf in normalization?

777


Can I use sql azure as a backup with log shipping or database mirroring?

148


what is denormalization? : Sql server database administration

705


Does a full backup include transaction log?

735