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
Give main differences between "Truncate" and "Delete".
Write a program using SQL queries to find a unique entry in a table.
When would you use the stored procedures or functions?
What is database black box testing?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
How much does sql server 2016 cost?
What is enhanced database mirroring in sql server 2008?
Define indexes?
What is the purpose of grouping data in a report?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is the difference between dbcc indexdefrag and dbcc reindex?
Differentiate between a having clause and a where clause.
explain databases and sql server databases architecture? : Sql server database administration
what are the reporting service components in SSRS?
What is a non-clustered index?