Difference between Triggers and Stored Procedure
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
What is precedence constraint?
What are four major operators that can be used to combine conditions on a where clause?
what is a self join? : Sql server database administration
What will happen if a column containing char type data is changed to the nchar data type?
How to create a new table in a given schema?
Explain different types of collation sensitivity?
Tell me what is difference between clustered and non clustered index?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
User wants only to display only pdf as export option in report manager. How to achieve this?
What is the most common type of join?
What is join and name different type of joins?
How can you append an identity column to a temporary table?
What is a document index?
What is plan freezing?
Can you create a logon trigger in sql server 2005 express edition?