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
- 112971 Views
- College School Exams Tests, HCL, Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / chauhan rakesh botad
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 ? | 2 Yes | 3 No |
Post New Answer View All Answers
what is raid? : Sql server database administration
How to create a simple stored procedure in ms sql server?
What is the most common type of join?
what are different types of backups available in sql server? : Sql server database administration
What are the disadvantages of indexes?
What is it unwise to create wide clustered index keys?
what is the system function to get the current user's user id? : Sql server database administration
Explain datetime2 data type in sal server 2008?
optimization techinques
How to provide default values to function parameters?
What is report server project?
What is the use of “join” in sql server?
Can you explain about buffer cash and log cache in sql server?
How to create a user to access a database in ms sql server using "create user" statements?
How to create new tables with "create table" statements in ms sql server?
