Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between stored procedure and function?
- 3 Answers
- 7591 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
How to list all field names in the result set using mssql_field_name()?
What is the difference between a function and a stored procedure?
What is normalization and its types?
Explain steps of normalization?
Mention the differences between substr and charindex in sql server.
How do I find the size of a sql server database?
What is the cpu pressure?
What is an execution plan? How would you view the execution plan?
what are the new features in SSRS?
what stored procedure can you use to display the current processes? : Sql server administration
what are constraints? : Sql server database administration
How to generate create function script on an existing function?
List the different types of joins?
What is the primary use of the model database?
What are “unrepeatable reads”?
