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
Why we use the openxml clause?
How do you delete duplicate records in sql server?
What is meant by dirty read?
Can you import Microsoft Excel data to SSRS?
What is scheduled job and how to create it?
What are various ways to enhance the ssrs report?
what is the difference between Tabular and Matrix report?
What is the sql case statement used for?
How can you start sql server in different modes?
How to list all dsn entries on your local machine using odbc_data_source()?
How to update muliple row in single query?
What is 2nf in normalization?
Can I use sql azure as a backup with log shipping or database mirroring?
what is denormalization? : Sql server database administration
Does a full backup include transaction log?