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 difference between unique and primary key?
What is a file group?
What is an index in a database?
How to concatenate two binary strings together?
Explain alternate key, candidate key and composite key in sql server?
What do you mean by an execution plan? Why is it used? How would you view it?
Explain what stored procedure sp_replcounters is used for? : sql server replication
What is implicit cursors?
What is a transact-sql statement?
Can you import Microsoft Excel data to SSRS?
How to turn on the mssql api module in php?
what is spatial nonclustered index
where can you add custom error messages to sql server? : Sql server administration
Explain the concepts and capabilities of sql server?
What is #temp and @table variable in SQL server?