Difference between Triggers and Stored Procedure
Answer Posted / veerababu
Stored Procedure is a method.
Trigger is a Procedure.
Stored Procedure a specific CALL or EXECUTE has be used.
Trigger is automatically execute some specific events occure in table/views.
Stored Procedure return a Value.
Trigger is not return a value.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain filtered indexes?
What are the different types of sub-queries?
When we should use and scope of @@identity?
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?
How important do you consider cursors or while loops for a transactional database?
What do you mean by the term 'normalization'?
What is a matrix in ssrs?
How do I find the transaction log size in sql server?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
How many types of local tables are there in sql server?
What is the difference between insensitive and scroll cursor?
How do you delete duplicate rows in sql server?
Ways to improve the performance of a SQL Azure Database?
What is the difference between functions and scalar functions?
What is database dimension? : sql server analysis services, ssas