Difference between Function and Stored Procedure?
- 9 Answers
- 19024 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
What is an inner join?
How will you make an attribute not process? : sql server analysis services, ssas
How to execute stored procedure in select statement sql server?
How to copy data from one table to another table?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
How to include date and time values in sql statements?
Do you know the capabilities of cursors?
What is a subquery in a select query statement in ms sql server?
What is sqlservr.exe - process - sql server (sqlex?press)?
How to handle error or exception in sql?
What the different topologies in which replication can be configured?
What is the osql utility?
What is purpose of normalization?
Can we add our custom code in ssis?
Why are you getting errors when creating a new odbc dsn?
