What is difference between stored procedure and function?
- 3 Answers
- 6580 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / a.suresh
1.Stored Procedure return 0 to nth value where as function
return only one value which is must.
2.we can't use the stored procedure in select select
statement where as function can be used in the select statement.
3.we can use all the dml(insert,update,delete) commands in
stored procedure where as select statement only used in
functions.
4.we can use try catch in stored procedure where as in
functions cant.
function must be used with its schema where as stored
procedure used with out schema name
ex.dbo.function name
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is explicit cursors?
How do I install only the client tools of sql server 2000?
What is blocking?
Explain activity monitors
What is read committed?
How many types of stored procedures are there in sql server?
How to replace given values with null using nullif()?
What is difference between temp table and cte?
What is user defined stored procedures?
Explain nested join?
What are transactions in sql?
What is named calculation? : sql server analysis services, ssas
Do you know how to implement service broker?
How except clause is differs from not in clause?
How do you test your database? : sql server database administration
