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 are the different normalization forms?
Where the sql logs gets stored? : sql server database administration
What is implicit cursors?
Why does sql studio use a single registered database repository? : sql server management studio
How can sql server instances be hidden? : sql server security
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
What do you understand by triggers and mention the different types of it?
Is t sql the same as sql server?
How will you find out if there are expensive SQL statements running or not?
What are the disadvantages of using the stored procedures?
How to find related tables in sql server?
what is a sub-report?
List the different normalization forms?
Explain about unique identifier data type in sql server?
Explain something about security and SQL Azure?