Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between stored procedure and function?
- 3 Answers
- 7758 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
Can I disable or restrict ssrs export formats (rendering formats)?
How many levels of sp nesting is possible?
How to set the current database in ms sql server?
How do you clear a log file?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Which language rdl files made of?
what protocol both networks use? : Sql server database administration
What is the difference between locking and multi-versioning?
Explain different types of Normalization.
Please explain go command in sql server?
Explain the functionalities that views support?
how to define testing of network layers? : Sql server database administration
Explain what is public role in sql server?
What is ms sql server service broker?
Explain difference between control flow and data flow?
