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
Define full outer join in sql server joins?
Why should we go for stored procedures? Why not direct queries?
What are basics of policy management?
What factors you will consider calculating the storage requirement for that view?
What is database mirroring?
What are the types of subscriptions in SQL Server replication?
Why I am getting this error when dropping a database in ms sql server?
How we create SQL Server 2005 Reporting Services ? Give me Sample
How does recursive cte works in sql server?
What do you mean by sql server 2005 express management tools?
How to find tables without indexes?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
Explain what is analysis service repository?
How to recreate an existing index in ms sql server?
What are the difference between primary key and unique key? : sql server database administration