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
Can sql servers linked to other servers?
What are the restraints imposed on the table design by a merge replication?
Do you know what is blocking?
what are candidate key, alternate key and composite key? : Sql server database administration
What is stored procedures?
What are the kinds of subquery?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is a data source or ds? : sql server analysis services, ssas
what are acid properties? : Sql server database administration
How to retrieve error messages using mssql_get_last_message()?
Explain how to send email from sql database?
How to change the system date and time from SQL Plus Terminal ?
What is open database communication (odbc)?
What are a scheduled jobs?
Can a trigger be created on a view?