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

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3608


Can two tables share a primary key?

746


What is the purpose of self join?

693


How to enable/disable indexes?

805


How to select some specific rows from a table in ms sql server?

795


List out some of the requirements to set up a sql server failover cluster?

796


What is difference between aggregate and analytic function?

684


why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

822


can an order by clause be used in a creation of a view?

914


How you can get the list of largest tables in a database?

710


Explain about builtinadministrator?

807


Can we check locks in database? If so, how can we do this lock check?

733


What are the default system databases in sql server 2000?

726


How optimize sql query with multiple joins in sql server?

613


What is a primary key?

722