Difference between Triggers and Stored Procedure
- 23 Answers
- 70144 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
What is the difference between varchar and varchar(max) datatypes?
How do you rebuild an identity column?
How to select some specific columns from a table in a query in ms sql server?
What are trace flags?
What options are available to audit login activity? : sql server security
What is sql view?
Explain about sql server login?
How can you ensure that the database and sql server based application perform well?
How do I find the size of a sql server database?
Explain the first normal form(1nf)?
What are the differences between char and nchar in ms sql server?
What is sql server locking?
What is sql server 2000 work load governor?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
Does partitioning improve performance sql server?
