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.

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

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 .

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

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.

Answer / hytham raju

triggers are applied on a particular table /views
stored procedures are applied for particular data base

What is a dbms wizard?

0 Answers  

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

0 Answers  

What is the difference between nvl and nvl2?

0 Answers  

If any stored procedure is encrypted, then can we see its definition in activity monitor?

0 Answers  

What happens if you add a new index to large table?

0 Answers  

What happens if you delete a table that is used by a view?

0 Answers  

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

0 Answers   Verizon,

When you first load SQL SERVER you will startup with what all databases?

3 Answers   CompuSol,

Explain left outer join and right outer join?

0 Answers  

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

0 Answers  

WHAT IS UNIQUE IDENTIFIER DATA TYPE?

2 Answers   Sparsh,

How many types of system privileges are there, Can we add or delete privileges?

2 Answers