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 save transaction and save point?

899


Write an SQL query to obtain the 2nd highest salary.

858


Does a specific recovery model need to be used for a replicated database? : sql server replication

763


What is bookmark link in ssrs?

155


how you can get the list of largest tables in a database? : Sql server administration

774


What is ms sql server triggers?

762


How to retrieve error messages using odbc_errormsg()?

780


Explain Geometry datatype in sql server 2008 with example

783


what is a deadlock? : Sql server database administration

741


What are the mathematical functions supported by sql server 2005?

807


How to use transact-sql statements to access the database engine?

807


Does partitioning improve performance?

769


what is the system function to get the current user's user id? : Sql server database administration

794


How do you check sql server is up and running?

741


Write a query to find 5th highest amount paid from the customer table.

743