Difference between Function and Procedure-in general?
Answer Posted / mona
Function can return at most one value at a time while
procedure can return more than one value at a time You can
use function within Sql Statement and you cannot use stored
procedure with in Sql Statement
| Is This Answer Correct ? | 19 Yes | 11 No |
Post New Answer View All Answers
Explain what role entity and relationship play in an ER diagram.
Explain what is log shipping?
Can we call stored procedure in view in sql server?
What are the types of indexes?
What is lock escalation? : sql server database administration
Can I disable or restrict ssrs export formats (rendering formats)?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
Explain some stored procedure creating best practices or guidelines?
What is user-defined inline table-valued function?
How to list all columns in a table using odbc_columns()?
What are views used for?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
write an SQL query to list the employees who joined in the month of January?
What is data source document?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration