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.

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).

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.

What is log cache in sql server?

0 Answers  

---

What is query optimization process?

0 Answers  

---

What is a full text index?

0 Answers  

---

What do you mean by an execution plan?

0 Answers  

---

How to delete multiple rows with one delete statement in ms sql server?

0 Answers  

---

What is query and its types?

0 Answers  

---

What is the difference between a local and a global variable?

5 Answers  

---

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

0 Answers   Satyam,

---

Describe in brief databases and sql server databases architecture.

0 Answers  

---

How are the exceptions handled in sql server programming?

0 Answers  

---

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

0 Answers  

---

What is better - 2nd Normal form or 3rd normal form? Why?

2 Answers   TCS, TPK,

---