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 happens to a trigger with multiple affected rows?
What is the default port for SQL Server over a firewall?
What are the differences between left join and inner join in sql server?
explain different types of joins? : Sql server database administration
What is reference section?
Tell me can we use custom code in ssrs?
What is clustered primary key?
How can a user-defined datatype be created?
What is the maximum rows in sql server table?
Where are sql server usernames and passwords stored in the sql server?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
Explain system functions or built-in functions? What are different types of system functions?
What is the difference between count () and rowcount ()?
What is store procedure?
How to create user defined functions with parameters?