Wht is the difference between stored procedure and trigger
Answers were Sorted based on User's Feedback
Answer / rajvelur
STORED PROCEDURE
A stored procedure is an already written SQL statement that
is saved in the database. We can run the stored procedure
from the database's command environment
1.Precompiled execution. SQL Server compiles each stored
procedure once and then reutilizes the execution plan. This
results in tremendous performance boosts when stored
procedures are called repeatedly.
2.Reduced client/server traffic. If network bandwidth is a
concern in your environment, you'll be happy to learn that
stored procedures can reduce long SQL queries to a single
line that is transmitted over the wire.
3.Efficient reuse of code and programming abstraction.
Stored procedures can be used by multiple users and client
programs. If you utilize them in a planned manner, you'll
find the development cycle takes less time.
4.Enhanced security controls. You can grant users permission
to execute a stored procedure independently of underlying
table permissions.
TRIGGER
A trigger is an object contained within an SQL Server
database that is used to execute a batch of SQL code
whenever a specific event occurs. As the name suggests, a
trigger is “fired” whenever an INSERT, UPDATE, or DELETE SQL
command is executed against a specific table.
Is This Answer Correct ? | 29 Yes | 3 No |
Answer / jerry joseph
Stored Procedures does not execute automatically
Triggers are a special type of Stored procedure which
executes automatically
Types of Triggers
- INSTEAD OF triggers
- AFTER Triggers
Is This Answer Correct ? | 15 Yes | 5 No |
Answer / anand
SRTORED PROCEDURES : STORED PROCEDURES IS A SET OF SQL
STATEMENT WHICH CAN NOT EXECUTES AUTOMATICALLY.
TRIGGERS : TRIGGERS IS A STORED PROCEDURE AND EXECUTES
AUTOMATICALY. IF ANY CHANGES OCCURED IN A TABLE OF DATABASE
I.E. INSERT, UPDATE OR DELETE STATE IS OCCURED IN TABLE IT
FIRED AUTOMATICALY .
Is This Answer Correct ? | 13 Yes | 6 No |
Answer / sujit kumar suman
Store Procedure:-It is a pre-compiled object which stored in
current database.It can't execute automatically.
--create store procedure
create proc procedure_name
as
select command
and then
go
--execute procedure
exec procedure_name
Is This Answer Correct ? | 6 Yes | 2 No |
Answer / rakesh
A stored procedure can be created with no parameters, IN
parameters, OUT parameters, or IN/OUT parameters. There can
be many parameters per stored procedure.
It is also called as a FUNCTION.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / hytham raju
triggers are applied on a particular table /views
stored procedures are applied for particular data base
Is This Answer Correct ? | 0 Yes | 0 No |
Define magic tables in sql server?
Explain transaction isolation levels in sql server?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
Can you explain what is indexed view? How to create it?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
Can we add our custom code in ssis?
What is transaction server consistency?
How do I find the sql server database version?
How to write stored procedure to update the data in 10 tables
How to delete duplicate records based on single column from a table?
0 Answers Petranics Solutions,
What is the use of keyword with encryption.
Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?