Skip to content
C# Corner
Searcharticlesvideosblogsforumsinterview questionsarticles
  • CSharp TV
  • Videos
  • Tech
  • Articles
  • Blogs
  • News
  • Forums
  • Books
  • Events
    • Interviews
    • Jobs
    • Stories
Login
  • Article
  • Blog
  • Video
  • Ebook
  • Interview Question
Loading
Upcoming Events
View all
  • 23 NOV
    AI Agents Conference 2026 - 3rd Edition
  • 5 DEC
    .NET Conf Local - Rasipuram

Latest Forum Questions

View all
  • HS

    i need help in transferring my pst files

    Himanshu Sharma·2d ago0
  • G

    Performance Improvements and Optimization Features in the Latest Python Release

    G.Devi·3d ago2
  • NJ

    How are people using AI for local SEO in 2026?

    Naomi jason·3d ago7
  • HS

    how can i save my gmail data as pdf for offline access?

    Himanshu Sharma·5d ago1
  • S

    Can I recover SQL Server database records along with the documents stored in them?

    samaira·5d ago4
About UsContact UsPrivacy PolicyTermsBrand GuidelinesPartnersC# TutorialsConsultantsIdeasReport A BugFAQsSitemapStoriesCSharp TVDB TalksWeb3 UniverseJumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Difference between the Stored Procedures and Trigger
  1. Home
  2. Technologies
  3. .NET
.NET

Difference between the Stored Procedures and Trigger

Senthilkumar

Senthilkumar

15yPublished Dec 24, 2011, 12:00 AMUpdated Dec 24, 2011, 4:36 AM19.4k00
Reactions
25Blog

Comments

Join the conversation! Your thoughts help the community grow.

Sign in to leave a comment

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign inCreate an account
  • 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.