Difference between Triggers and Stored Procedure
- 23 Answers
- 68195 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / avdhesh yadav
1. Stored Procedure may Return a value but Trigger Not,
2. In Stored Procedure you can pass parameter But in
trigger you can't
3. we explicitly call the Stored Procedure when Trigger are
implicitly
fired
4. you can write a Stored Procedure in Trigger but in a
Trigger you cant
write Stored Procedure.
5. Trigger written on an individual Table or View where
Stored Procedure
is written for an Database
| Is This Answer Correct ? | 29 Yes | 7 No |
Post New Answer View All Answers
Which is faster statement or preparedstatement?
Do you know the different ddl commands in sql?
How to recreate an existing index in ms sql server?
What is bookmark link in ssrs?
What is a recursive stored procedure in sql server?
How many database files are there in sql server 2000?what are they?
How do I view a script in sql server?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What is parameterized reports in ssrs ?
What number sorts of privileges are accessible in sql?
How many databases Microsoft SQL server provides?
Do you know what are various aggregate functions that are available?
Can we use where clause with group by?
Explain about remote stored procedure?
Why normalization is used?
