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
How can change procedure in sql server?
How to connect to a sql server using odbc_connect()?
How do I find the sql server version?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What is the stored procedure?
How to round a numeric value to a specific precision?
Do you know what are the restrictions that views have to follow?
What are the different editions available in sql server 2000?
What is the benefit of normalization?
What gets stored inside msdb database?
What is a trace frag?
What are the types of table?
What are different types of subquery?
How to use subqueries with the exists operators in ms sql server?
Describe how to use the linked server?