when we use function instead of procedure? plz tell me the
situation with ex?
Answer Posted / manoj
Usually procedures are used when some action is to be
performed without retrun value.
Functions are used when some value is to be returned to the
calling enviornment.
You can not use procedure in the select statement however
functions can be used.
Is This Answer Correct ? | 30 Yes | 0 No |
Post New Answer View All Answers
What is an expensive query?
What does the on delete cascade option do?
Explain full-text indexing?
Who developed sql server?
What are user-defined functions (udfs) in sql server?
What are data driven subscriptions?
How do I delete a sql server database?
Can you please explain the difference between function and stored procedure?
Find first and last day of current month in sql server
What is the bookmark lookup and rid lookup?
What is the use of keyword with encryption. Create a store procedure with encryption?
How to find the version of sql server? : sql server database administration
Explain differences between web edition and business edition?
How to test subquery results with the exists operator?
Is mysql better than sql server?