Difference between Function and Stored Procedure?
Answer Posted / raj..
The difference mejor between procedure and function is that
function must return value. that should be only single and
function can pass any no. parameter but come out only one
value only using return statement.
procedure can pass any parameter and came out any no. of
values there no any RETURN word.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are the types of subscriptions in SQL Server replication?
What is temporal data type?
What is difference between index seek vs. Index scan?
What are the requirements to use odbc connections in php scripts?
Can sql server be linked with other servers like oracle?
How to use union to merge outputs from two queries together in ms sql server?
How to create percentile function?
in the physical file layout, where should the transaction log be stored in relation to the data file?
Explain “not null constraint” in sql server?
What are functions in the sql server?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
How would you add a section to a table?
Do you know what are the steps to process a single select statement?
Explain sub-query?
What is query optimization process?