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 |
Does any body please help me what question's have asked for SSRS in the interview?
Is foreign key a primary key?
How to select nth record from a table?
13 Answers DELL, Microsoft, Ramco,
Will count(column) include columns with null values in its count?
what is the main difference between constraints(like primary key etc..)& joins?
How to Run a Query on a Remote SQL Server?
What is the difference between dropping a database and taking a database offline?
What is sql language?
What is difference between order by and group by?
What are the two types of concurrency?
Define tool Manage Statistics in SQL Server 2000 query ?
which one will take 1st priority in case of insert statement and select statement???