New Feature: Mention your friends and followers
Go to all article comments >>
Go to all messages >>
A Code Snippet
An Interview Question
Ask a Question
Printing in C#
Visual Studio 2010
Visual Studio 2012
Databases & DBA
Visual Studio 2013
WCF with C#
Design & Architecture
Mobile & Embedded
Reports using C#
Multithreading in C#
Web Services in C#
Games Programming C#
How do I
Windows Forms C#
Internet & Web
Windows Store Apps
Visual Basic .NET
Visual Studio .NET
C, C++, MFC
Request a new Category
Categories of Sql Commands
Deserialize a nested json in c#
Rotate an Image Based on the User ...
How to check if the user exists in ...
How to hide the page tab using Jav ...
Access Model State Property within ...
Difference between Claims-based Au ...
Web Service Availabilty Check
Update Logout Time in Database whe ...
Generating/Updating a Code Behind ...
Difference between the Stored Procedures and Trigger
Dec 24, 2011
The stored procedures and triggers are very important objects in the databases. This blog helps to understand the key difference between these.
The stored procedures used for performing task
The stored procedures normally used to performing user specified tasks. It can have the parameters. It can return multiple results set.
The Triggers for auditing work
The triggers normally used for auditing work. It can be used to trace the activities of the table events.
The stored procedures can have the parameters
The procedures can have the input and output parameters with all the data types available in the sql server as well as user defined data types.
The Triggers cannot have any parameters
The triggers cannot have any parameters.
The stored procedure can be run independently
The stored procedures can be run independently .It stores as a database object. It can be called from the application.
The triggers executes based on table events
The DML triggers are get executed based on the table events defined on the particular table. There are different types of triggers like DML triggers, DDL triggers (from 2005 onwards) and logon triggers (from 2008 onwards).
The DDL triggers can control the stored procedures creation, drop, ect.,
The stored procedure cannot call triggers
The stored procedures cannot call the triggers directly. But when we do the DML operations on the table, if the corresponding table has the trigger then that time it will get trigger.
The triggers can call stored procedures
The triggers can call the stored procedures.
View Previous Comments >>
Hire Mobile & Web Developer
Hire Mobile & Web Developer on demand. 100% satisfaction. Try for 1 week or Money Back. Local and remote developers available all over USA.
Introduction to Search Administration Component in SharePoint 2013
Introcution to Query Processing Component in SharePoint 2013 Search
What is Index Component in SharePoint 2013 Search
Understanding SAML Token-Based Authentication in SharePoint 2013
OAuth 2.0 in SharePoint 2013
Website under maintenance
Round Button in WPF
Bulk Copy in SQL server using c#.net
How to Get Comma Separated values in SQL Server with STUFF and CROSS APPLY keywords
Deserialize a nested json in c#
CBeyond Cloud Services
TERMS & CONDITIONS
©2014 C# Corner. All contents are copyright of their authors.