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
Can We Use Data-grids For Our Report In Ssrs?
What are diverse clauses that form a part of sql?
Explain unique key in sql server?
What does Master database contains?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
Explain how does the report manager work in ssrs?
What triggers long term care?
How can delete duplicate records in cte in sql server?
Explain concepts of analysis services?
What are views in ms sql server?
Why variables called the most powerful component of ssis?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
How will you hide an attribute? : sql server analysis services, ssas
How to convert character strings into numeric values?
Tell me what is the significance of null value and why should we avoid permitting null values?