Difference between Triggers and Stored Procedure
Answers were Sorted based on User's Feedback
Answer / rajani kant
stored procedure
Definition
please give me Answer
Is This Answer Correct ? | 34 Yes | 36 No |
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 |
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 |
What is data block and how to define data block size?
Do you know what are acid properties of transaction?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
Can you insert NULL in unique column?
Explain transaction server distributed transaction?
Can you create a logon trigger in sql server 2005 express edition?
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?
tell me the disaster recovery plan
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
If we use where clause in the left outer join then how the query would behave/act?
What is executereader?
What is use of @@ spid in sql server?