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 the difference between push and pull subscription? : sql server replication
What are trace files?
Name the different type of indexes in sql?
What is the function of sql server agent windows service?
How to delete duplicate rows?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
What is a schema in ms sql server 2005?
What is the name of the Database which IBM mainframe uses?
What is sharding?
How do I find the sql server database version?
What is the purpose of a table?
Explain what is lock escalation and what is its purpose?
What is a subquery in a select query statement in ms sql server?
What are “lock” hints?
Explain the stored procedure?