MindFusion's Components
Home | Submit an interview question | Filter by category | Filter by job function | Filter by company
 
Member Information
User Id
Password
 
Forgot Password
Technology Category
.NET (1202)
Languages (103)
Database (146)
Operating System (48)
Reporting (5)
Third-Party Tools (2)
Testing (91)
OOP (75)
Web Development (40)
Design Patterns (89)
General (9)
Networking (88)
Hardware (63)
Brain Exercise (2)
Others (37)
 Our Network
.NET Heaven
C# Corner
Interview Corner
Longhorn Corner
Mindcracker
VB.NET Heaven
Home » Database » Database
Difference between Store Procedure and Trigger?
Posted by Purushottam Rathore Jul 29, 2009
Viewed : 1121 times
Major Category : Database
Minor Category : SQL Server
Total Replies : 2
Sponsored by
Become a Sponsor
 EDITORIAL ANSWER  
No Reply Yet
 ANSWERS BY USERS  
Erode Senthilkumar
Aug 07, 2009
Stored procedure normally used for performing tasks
But the Trigger normally used for tracing and auditing logs.

Stored procedures should be called explicitly by the user in order to execute
But the Trigger should be called implicitly based on the events defined in the table.

Stored Procedure can run independently
But the Trigger should be part of any DML events on the table.

Stored procedure can be executed from the Trigger
But the Trigger cannot be executed from the Stored procedures.

Stored Procedures can have parameters.
But the Trigger cannot have any parameters.
Purushottam Rathore
Jul 29, 2009

Store Procedure we need execute manually, trigger fired when the event is occured(insert ,delete,update,..etc).
  
1
World Class ASP.NET Hosting - 3 Month Free Hosting, Click Here!
 

 Hosted by MaximumASP  |  Found a broken link?  |  Contact Us  |  Terms & conditions  |  Privacy Policy  |  Advertise with us
Current Version: 2.2009.3.2
 © 1999 - 2009  Mindcracker LLC. All Rights Reserved