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

Explain different types of locks in sql server.

595


How to create a simple user defined function in ms sql server?

543


Detail about the hardware which is supported by SQL server?

581


How can we remove orphan records from a table?

524


How to disable stored procedure sql server?

958






Do you know the different ddl commands in sql?

590


Can you tell me some of the common replication dmv's and their use? : sql server replication

533


What stored by the master?

543


What is the openxml statement in sql server?

536


Tell me what do you understand by a view? What does the with check option clause for a view do?

639


How to find which stored procedure is currently running in sql server?

488


Tell me when is the update_statistics command used?

506


How many triggers are possible per table?

622


what is a mixed extent? : Sql server administration

601


What are the 2 types of classifications of constraints in the sql server?

582