when we use function instead of procedure? plz tell me the
situation with ex?
Answer Posted / adil khan
procedure can only use in plsql not in sql. in other words
you can not use procedure in your select satatement. only
funtion can be used for example max(),min(),Avg() these all
are funtion not procedure.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is co-related sub query?
Explain microsoft sql server functions?
What are the differences between ms sql server & oracle?
What are page splits? : SQL Server Architecture
What is raid and what are different types of raid levels?
How to get the definition of a stored procedure back?
Explain what is meant by replication of database?
What are the different authentication modes in sql server?
What is db stored procedure?
What is similarity and difference between truncate and delete in sql?
Does the unique constraint create an index?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
Why are sql functions used?
What is read uncmmited?
What is reportserver and reportservertempdb ?