Wht is the difference between stored procedure and trigger

Answer Posted / rakesh

A stored procedure can be created with no parameters, IN
parameters, OUT parameters, or IN/OUT parameters. There can
be many parameters per stored procedure.

It is also called as a FUNCTION.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is snapshot parameter in ssrs?

109


What is the beast way to write CTE in SQL Server ?

555


How do you identify a foreign key?

593


What is normalization 1nf 2nf 3nf?

624


How to invoke a trigger on demand?

534






How to create and drop temp table in sql server?

585


Explain different types of index?

588


Describe in brief databases and sql server databases architecture.

521


What is isolation levels?

562


What is the optimization being performed in oracle and SQL Server?

617


What is meant by Active-Passive and Active-Active clustering setup?

550


How do I setup a sql server database?

535


what authentication modes does sql server support? : Sql server database administration

514


What are truncate options available in sql server? : sql server database administration

579


How to encrypt data between dialogs?

563