Difference between Triggers and Stored Procedure
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 SQL Azure Federations?
How you can add messages to the nt event log from within a stored procedure?
What is sql server locking?
What happens if date-only values are provided as date and time literals?
How do I make a resultset scrollable?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
Can we call stored procedure in trigger?
What are the default system databases in sql server 2000?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
Data table as parameter in sql server?
How to insert multiple rows with a subquery?
How to change server name in sql server?
What is indexed view? How to create it?
What the class forname () does?
What do you mean by an execution plan?