Difference between Triggers and Stored Procedure
- 23 Answers
- 74825 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / ghanshyam vrema
1. SP may Return a value but Trigger Not,
2. In SP you can pass parameter But in trigger you can't
3. we explicitly call the Sp when Trigger are implicitly
fired
4. you can write a sp in Trigger but in a Trigger you cant
write SP.
5. Trigger written on an individual Table or View where SP
is written for an Database
| Is This Answer Correct ? | 75 Yes | 43 No |
Post New Answer View All Answers
List out the different types of locks available in sql server?
What is clustered index
What is the difference between for xml raw and for xml auto?
How to remove duplicate rows from table except one?
what is spatial nonclustered index
What is temporary table in sql server? Why we use temp table?
What is sql or structured query language?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How efficient you are in oracle and SQL server?
Disadvantages of the indexes?
Explain “row_number()” in sql server with an example?
What is a coalesce function?
What is acid mean in sql server?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
How do I find query history in sql server?
