{"id":4463,"date":"2022-06-04T05:41:20","date_gmt":"2022-06-04T05:41:20","guid":{"rendered":"https:\/\/www.wikitechy.com\/interview-questions\/?p=4463"},"modified":"2022-06-04T05:41:20","modified_gmt":"2022-06-04T05:41:20","slug":"difference-between-trigger-and-stored-procedure-in-dbms","status":"publish","type":"post","link":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-trigger-and-stored-procedure-in-dbms\/","title":{"rendered":"Difference between Trigger and Stored procedure in DBMS"},"content":{"rendered":"\n\n\n\n\n\n\n\n\n\n
\n

Triggers<\/strong><\/p>\n<\/td>\n

\n

Stored Procedures<\/strong><\/p>\n<\/td>\n<\/tr>\n

A Trigger is created in such a way that it fires when a specific event occurs.<\/td>\nA group of sql commands that can be reused again and again are called stored procedures. They are created and stored in a database.<\/td>\n<\/tr>\n
A trigger cannot be called or\u00a0execute\u00a0directly by a user.\u00a0 Only when the corresponding events are fired, triggers are created.<\/td>\nStored procedures can be executed whenever wanted by using exec command.<\/td>\n<\/tr>\n
Trigger cannot be scheduled.<\/td>\nYou can schedule a job to execute the stored procedure at a pre-defined time.<\/td>\n<\/tr>\n
Calling a trigger within a trigger is not possible<\/td>\nCalling a stored procedure within a stored procedure is possible<\/td>\n<\/tr>\n
You cannot pass parameters as input.<\/td>\nInputs can be passed as parameters<\/td>\n<\/tr>\n
\u00a0It does return a value<\/td>\nCan\u00a0return\u00a0zero or n values.<\/td>\n<\/tr>\n
In a trigger, we cannot perform any transactions<\/td>\nYou can use\u00a0transactions\u00a0within a stored procedure.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/p>\n

\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"

Triggers Stored Procedures A Trigger is created in such a way that it fires when a specific event occurs. A group of sql commands that can be reused again and again are called stored procedures. They are created and stored in a database. A trigger cannot be called or\u00a0execute\u00a0directly by a user.\u00a0 Only when the […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7157],"tags":[17517,8152,17511,17525,17516,17521,17520,17515,17512,17514,17518,17523,17513,17522,17524,17519],"class_list":["post-4463","post","type-post","status-publish","format-standard","hentry","category-dbms","tag-3-triggers-and-stored-procedures","tag-difference-between-stored-procedure-and-function","tag-difference-between-stored-procedure-and-triggers-in-sql","tag-difference-between-stored-procedure-and-view","tag-difference-between-stored-procedures-and-triggers","tag-difference-between-transaction-and-stored-procedure","tag-difference-between-trigger-and-function","tag-difference-between-trigger-and-procedure","tag-difference-between-trigger-and-procedure-in-dbms","tag-difference-between-trigger-and-stored-procedure-in-dbms","tag-difference-between-trigger-and-stored-procedure-in-sql","tag-difference-between-trigger-and-stored-procedure-with-example","tag-sql-differences-between-stored-procedure-and-triggers","tag-trigger-stored-procedure-and-cursor-difference-and-uses","tag-triggers-will-be-called-by-stored-procedure","tag-what-is-the-difference-between-trigger-and-stored-procedure"],"yoast_head":"\nDifference between Trigger and Stored procedure in DBMS<\/title>\n<meta name=\"description\" content=\"Difference between Trigger and Stored procedure in DBMS - A Trigger is created in such a way that it fires when a specific event occurs.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-trigger-and-stored-procedure-in-dbms\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Difference between Trigger and Stored procedure in DBMS\" \/>\n<meta property=\"og:description\" content=\"Difference between Trigger and Stored procedure in DBMS - A Trigger is created in such a way that it fires when a specific event occurs.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-trigger-and-stored-procedure-in-dbms\/\" \/>\n<meta property=\"og:site_name\" content=\"Wikitechy\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-04T05:41:20+00:00\" \/>\n<meta name=\"author\" content=\"webmaster\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"webmaster\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/difference-between-trigger-and-stored-procedure-in-dbms\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/difference-between-trigger-and-stored-procedure-in-dbms\\\/\"},\"author\":{\"name\":\"webmaster\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/f785ba3ecc599133e65ab6138042a3e4\"},\"headline\":\"Difference between Trigger and Stored procedure in DBMS\",\"datePublished\":\"2022-06-04T05:41:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/difference-between-trigger-and-stored-procedure-in-dbms\\\/\"},\"wordCount\":161,\"commentCount\":0,\"keywords\":[\"3 Triggers and Stored Procedures\",\"difference between stored procedure and function\",\"Difference between stored procedure and triggers in SQL\",\"difference between stored procedure and view\",\"Difference Between Stored Procedures and Triggers\",\"difference between transaction and stored procedure\",\"difference between trigger and function\",\"Difference Between Trigger and Procedure\",\"Difference between Trigger and Procedure in DBMS\",\"Difference between Trigger and Stored procedure in DBMS\",\"Difference Between Trigger and Stored Procedure in SQL\",\"difference between trigger and stored procedure with example\",\"SQL Differences between stored procedure and triggers\",\"trigger stored procedure and cursor difference and uses\",\"triggers will be called by stored procedure\",\"What is the difference between Trigger and stored procedure?\"],\"articleSection\":[\"DBMS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/difference-between-trigger-and-stored-procedure-in-dbms\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/difference-between-trigger-and-stored-procedure-in-dbms\\\/\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/difference-between-trigger-and-stored-procedure-in-dbms\\\/\",\"name\":\"Difference between Trigger and Stored procedure in DBMS\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\"},\"datePublished\":\"2022-06-04T05:41:20+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/f785ba3ecc599133e65ab6138042a3e4\"},\"description\":\"Difference between Trigger and Stored procedure in DBMS - A Trigger is created in such a way that it fires when a specific event occurs.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/difference-between-trigger-and-stored-procedure-in-dbms\\\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/\",\"name\":\"Wikitechy\",\"description\":\"Interview Questions\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/f785ba3ecc599133e65ab6138042a3e4\",\"name\":\"webmaster\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g\",\"caption\":\"webmaster\"},\"sameAs\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\"],\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/author\\\/webmaster\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Difference between Trigger and Stored procedure in DBMS","description":"Difference between Trigger and Stored procedure in DBMS - A Trigger is created in such a way that it fires when a specific event occurs.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-trigger-and-stored-procedure-in-dbms\/","og_locale":"en_US","og_type":"article","og_title":"Difference between Trigger and Stored procedure in DBMS","og_description":"Difference between Trigger and Stored procedure in DBMS - A Trigger is created in such a way that it fires when a specific event occurs.","og_url":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-trigger-and-stored-procedure-in-dbms\/","og_site_name":"Wikitechy","article_published_time":"2022-06-04T05:41:20+00:00","author":"webmaster","twitter_card":"summary_large_image","twitter_misc":{"Written by":"webmaster","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-trigger-and-stored-procedure-in-dbms\/#article","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-trigger-and-stored-procedure-in-dbms\/"},"author":{"name":"webmaster","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4"},"headline":"Difference between Trigger and Stored procedure in DBMS","datePublished":"2022-06-04T05:41:20+00:00","mainEntityOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-trigger-and-stored-procedure-in-dbms\/"},"wordCount":161,"commentCount":0,"keywords":["3 Triggers and Stored Procedures","difference between stored procedure and function","Difference between stored procedure and triggers in SQL","difference between stored procedure and view","Difference Between Stored Procedures and Triggers","difference between transaction and stored procedure","difference between trigger and function","Difference Between Trigger and Procedure","Difference between Trigger and Procedure in DBMS","Difference between Trigger and Stored procedure in DBMS","Difference Between Trigger and Stored Procedure in SQL","difference between trigger and stored procedure with example","SQL Differences between stored procedure and triggers","trigger stored procedure and cursor difference and uses","triggers will be called by stored procedure","What is the difference between Trigger and stored procedure?"],"articleSection":["DBMS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-trigger-and-stored-procedure-in-dbms\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-trigger-and-stored-procedure-in-dbms\/","url":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-trigger-and-stored-procedure-in-dbms\/","name":"Difference between Trigger and Stored procedure in DBMS","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website"},"datePublished":"2022-06-04T05:41:20+00:00","author":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4"},"description":"Difference between Trigger and Stored procedure in DBMS - A Trigger is created in such a way that it fires when a specific event occurs.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wikitechy.com\/interview-questions\/dbms\/difference-between-trigger-and-stored-procedure-in-dbms\/"]}]},{"@type":"WebSite","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website","url":"https:\/\/www.wikitechy.com\/interview-questions\/","name":"Wikitechy","description":"Interview Questions","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wikitechy.com\/interview-questions\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4","name":"webmaster","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g","caption":"webmaster"},"sameAs":["https:\/\/www.wikitechy.com\/interview-questions"],"url":"https:\/\/www.wikitechy.com\/interview-questions\/author\/webmaster\/"}]}},"_links":{"self":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/4463","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/comments?post=4463"}],"version-history":[{"count":1,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/4463\/revisions"}],"predecessor-version":[{"id":4464,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/4463\/revisions\/4464"}],"wp:attachment":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/media?parent=4463"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/categories?post=4463"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/tags?post=4463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}