Difference between Function and Stored Procedure?
- 9 Answers
- 19069 Views
- C1 India, NA, I also Faced
- E-Mail Answers
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
How do you identify a foreign key?
Explain different backup plans?
What is dbcc? Give few examples.
Explain contrast amongst grouped and non-bunched records?
What are the advantages of using cte?
How to see the event list of an existing trigger using sys.trigger_events?
What is change data capture (cdc) feature?
How to enter binary string literals in ms sql server?
What are the steps to follow to configure SQL*Net?
Explain an automatic checkpoint
write an SQL query to list the employees who joined in the month of January?
Why and when do stored procedure recompile?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
How to rename an existing column with sql server management studio?
What is the definition for sql server 2000?
