What are the differences between stored procedure and
functions in SQL Server 2000?
- 25 Answers
- 106267 Views
- College School Exams Tests, HCL, Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / prashant
1>Procedure can return zero or n values whereas function can
return one value which is mandatory.
2>Procedures can have input,output parameters for it whereas
functions can have only input parameters.
3>Procedure allow select as well as DML statement in it
whereas function allow only select statement in it.
4>Functions can be called from procedure whereas procedures
cannot be called from function.
5>Exception can be handled by try-catch block in a procedure
whereas try-catch block cannot be used in a function.
6>We can go for transaction management in procedure whereas
we can't go in function.
7>Procedures can not be utilized in a select statement
whereas function can be embedded in a select statement.
| Is This Answer Correct ? | 22 Yes | 4 No |
Post New Answer View All Answers
Can you explain full-text query in sql server?
Explain trigger classes i.e. Instead of and after trigger?
What's the information that can be stored inside a bit column?
List types of tables in SQL Azure?
System variable and temporary variables
What is primary key index?
What is row_number function?
What are partitioned views?
How do you implement session management in SQL Server mode?
How to see existing views in ms sql server?
What is the command to change the recovery model?
What are the three different part of rdl file explain them?
What do you understand by intent locks?
How to get @@error and @@rowcount at the same time?
What will happen if a column containing char type data is changed to the nchar data type?
