Search:
Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in SQL Server Triggers

Interview Question :: Difference between trigger and procedure

related to sql

Answers to "Difference between trigger and procedure"

RE: Difference between trigger and procedure?
A trigger is a block of code that constitutes a set of transact-SQL statements that are activated in response to certain actions.it is fired whenever data in the underlying table is affected by any of the data manupulation language statement i.e, insert,update,delete. a procedure is a set of commands that are combined and stored. these are generally commands that r frequently used. they are not 'fired' like triggers.
Vote for this answer ::

RE: Difference between trigger and procedure is Trigger is block of code

which is initiating when Action taken by insert, update and deleting

But Procedure is a set of SQL statement, which is previously store in the Database

Vote for this answer ::

RE: Difference between trigger and procedure is
<p> Trigger is block of code which is initiating when Action taken by insert, update and deleting</p> <p>But Procedure is a set of SQL statement, which is previously store in the Database </p>
Vote for this answer ::

RE: Difference between trigger and procedure is

Trigger is block of code which is initiating when Action taken by insert, update and deleting But Procedure is a set&nbsp;of SQL statement,&nbsp;which is&nbsp;previously store in the Database&nbsp;

from

Nirmal Dutta

Vote for this answer ::

Notify me whenever an answer is posted for this question Update Alert Setting

Top Tags

- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers

Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in SQL Server Triggers

Interview Question :: Difference between trigger and procedure

Top Tags