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
How do I find information about the install locations for the various instances running on a computer?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
What is the need for group functions in sql?
Write SQL queries on Self Join and Inner Join.
Why use sub query in sql server and list out types of sub queries?
Mention the different authentication modes in sql server.
What is identity?
Is it important for a database administrator to understand the operating system and file access?
Explain an incremental backup?
What are the disadvantages of primary key and foreign key in SQL?
How to call a function from a stored procedure in SQL Server ?
How can i Relate Tables in SSIS
Explain triggers?
How to restore performance issues and how to check?