Difference between Triggers and Stored Procedure
Answer Posted / pankaj arya
To use stored procedure you have to make a call to that
procedure but Triggers fired automatically when an event is
occurred on the table associated with that Trigger like add,
insert or delete.
| Is This Answer Correct ? | 108 Yes | 7 No |
Post New Answer View All Answers
What is inner join? Explain with an example?
What is a view and what are its advantages?
Why use identity in sql server?
Why use “in” clause in sql server?
How to delete an existing database user?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
Write a query to find 5th highest amount paid from the customer table.
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
Does sql server use t sql?
Why is normalisation important?
What do you understand by hotfixes and patches in sql server?
What are the database objects? : SQL Server Architecture
Does partitioning ssd reduce performance?
what is isolation level at dead lock?