Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between stored procedure and
functions in SQL Server 2000?
- 25 Answers
- 112166 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
what is normalization? Explain different levels of normalization? : Sql server database administration
What is spatial and temporal data?
How to update a field in SQL after ALTERING a row?
What is report snapshot in ssrs?
What is transaction server explicit transaction?
What are the rendering extensions of ssrs?
How to download and install microsoft .net framework version 2.0?
What structure can you implement for the database to speed up table reads?
What is an etl file?
What is database replication?
Tell me what is difference between clustered and non clustered index?
What is server-level principal?
Characterize join and name diverse sorts of joins?
What is a primary key?
What is an entity-relationship diagram (erd)?
