Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 72741 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / madhu prakash p
sp and trigger are both predefined set of sql statements
we can pass the arguments for sp but we cant pass the
arguments for triggers.
trigger will fire implicitly, when ever relavent action
performed by the user on the tables where the triggers are
placed.
But in the stored procedures u must call explicitly.
| Is This Answer Correct ? | 43 Yes | 9 No |
Post New Answer View All Answers
Explain how to integrate the ssrs reports in application?
Do you know what are pages and extents? : SQL Server Architecture
What action plan is preferred if sql server is not responding?
What is the difference between locking and multi-versioning?
Write an sql query for deleting duplicate rows?
Explain syntax for disabling triggers?
What are drilldown reports?
Which autogrowth database setting is good?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
Difference between LEN() and DATALENGTH() in sql server ?
What is CTE in SQL
List the data types available in mssql?
What is measure group, measure? : sql server analysis services, ssas
How do I trace a query in sql server?
What are system databases into sql server (2005/2008) : sql server database administration
