Difference between Triggers and Stored Procedure
Answer Posted / ram
Stored Procedures are called by the programmer wherever it
wants to fire but triggers fired automatically when
insert,delete,update occured. And triggers can be
implemented to tables & views only where as s.p used in the
database independently
Is This Answer Correct ? | 135 Yes | 13 No |
Post New Answer View All Answers
What is mssql?
how to determine the service pack currently installed on sql server? : Sql server database administration
How to get all stored procedures in sql server?
What is query optimizer in sql server?
What is service broker? : sql server database administration
Explain logical operators in sql server?
What are the advantages to use stored procedures?
Why the trigger fires multiple times in single login?
What do mean by xml datatype?
What is cursor in ms sql server?
Can I disable or restrict ssrs export formats (rendering formats)?
What is the difference between substr and charindex in the sql server?
How to configure odbc dsn with different port numbers?
What is the process of normalising?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio