what is a stored procedure and trigger?
Answers were Sorted based on User's Feedback
Answer / ramesh
stored procedure:
Group of sql statements compiled into single execution plan.
create procedure sp_procedurename
as
begin
begin transaction
select * from table
if @@error=null
commit
else
rollback
end
Trigger
--------
Trigger is a set of sql queries which fire when an event
occurs(delete,update,insert).
in 2005 DDL TRIGGER INTRUDUCED.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sandeep
First of all both are precompiled sql statements stored at
database server.
1. Stored procedures can return values to the caller
whereas triggers cant.
2. we cant call a trigger directly becos it is called by
the database server on an event(automatically raised on
insert,update,delete statements).
3. triggers can access datas from outside world(outside of
the Database).
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / shashi kishor prasad
1.Stored Procedures are Pre-compiled functions that needs to
be called but Triggers are event driven and can't be called
explicitly like stored procedures
2.Stored procedures can take arguments but Triggers dont
take arguments.
3.Stored procedures cant get executed unless they are called
by by the calling program but Triggers gets fired as soon as
an event for which it has been created takes place.
4. Stored procedures can work on the database and values it
has been assigned but Triggers can work on db other than that.
5.Stored Procedures are used to make the execution faster
and to prevent from sql injections to some extent but
Triggers are used to achieve different tasks on occurrence
of an event like insert update and delete on a table.
Is This Answer Correct ? | 0 Yes | 0 No |
What are the difference between “where” and “having” clause in sql server?
How to use transact-sql statements to access the database engine?
Define candidate key, alternate key, and composite key.
Why is sql server log file full?
What does Master database contains?
What is sql profiler. What are the default templates with it? : sql server database administration
Does hive support indexing?
How many categories of data types used by sql server?
Is oracle faster than sql server?
CREATE a table from another table
in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.
What is the difference between dbcc indexdefrag and dbcc reindex?