Difference between Triggers and Stored Procedure

Answers were Sorted based on User's Feedback



Difference between Triggers and Stored Procedure..

Answer / rajani kant

stored procedure

Definition

please give me Answer

Is This Answer Correct ?    34 Yes 36 No

Difference between Triggers and Stored Procedure..

Answer / amar

triggers is a block of code where is fired to do something action for insertion or delation of varioue t- sql statement........ where triggers are automatically fired.........

stored procedure is a predefined data types which is stored in a database............ stored procedure has to fire...........

Is This Answer Correct ?    0 Yes 2 No

Difference between Triggers and Stored Procedure..

Answer / love is my pation

i am saying to this web case if they understand what is the
differences between start and triggered. and if you know
please tell me.

Daaaaaaaaaaaaaaaaaaaaa!!!!!!!!!!1

Is This Answer Correct ?    1 Yes 4 No

Post New Answer

More SQL Server Interview Questions

What is data block and how to define data block size?

0 Answers  


Do you know what are acid properties of transaction?

0 Answers  


What is the guest user account in sql server? What login is it mapped to it? : sql server security

0 Answers  


Can you insert NULL in unique column?

0 Answers   MCN Solutions,


Explain transaction server distributed transaction?

0 Answers  


Can you create a logon trigger in sql server 2005 express edition?

0 Answers  


create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,


tell me the disaster recovery plan

0 Answers   Microsoft,


How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

2 Answers  


If we use where clause in the left outer join then how the query would behave/act?

1 Answers  


What is executereader?

0 Answers  


What is use of @@ spid in sql server?

0 Answers  


Categories