Difference between Triggers and Stored Procedure

Answer Posted / gopal chauhan

Stored Procedure can give one output paramenter,but
Triggers can not give any output parameter

Is This Answer Correct ?    61 Yes 20 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is clr ddl trigger?

724


What is etl - extraction, transformation, and loading?

667


What is the dbcc command and why is it used?

760


What’s the distinction between dropping a info and taking a info offline?

805


Do you think BCNF is better than 2NF & 3NF? Why?

999






How to set the current database in ms sql server?

719


How data can be copied from one table to another table?

699


Which rendering formats are affected by the pagesize properties?

122


You are doing log shipping due to some reasons it is failing. How you will proceed from there

1750


What is set nocount on?

682


Define inner join in sql server joins?

715


What to perform pattern match with the like operator?

657


What is the query and subquery?

806


What is 'write-ahead log' in sql server 2000 ?

794


On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

850