what is the difference between procedure and function.
- 4 Answers
- 7894 Views
- Thomson, I also Faced
- E-Mail Answers
Answer Posted / saurav kumar
1) Inside Stored procedure we can write functions but
inside function we can't write Stored procedures.
2) Stored proedure may or may not return a value but
function must return a value.
3) Stored Procedures can be called independently using exec
keyword ,Function are called using select statement.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can change procedure in sql server?
What is query optimization process?
Explain “row_number()” in sql server with an example?
Why do we use stored procedures in sql server?
how you can move data or databases between servers and databases in sql server? : Sql server administration
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
Explain different types of Normalization.
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What are the disadvantages of indexes?
optimization techinques
How you trouble shoot when any job fails
What do you mean by 'normalization'?
Define outer join?
What is replication and database mirroring?
What extended events?
