when we use function instead of procedure? plz tell me the
situation with ex?
- 3 Answers
- 9834 Views
- IBM, I also Faced
- E-Mail Answers
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
Define right outer join in sql server joins?
Explain the different index configurations a table can have?
What is row_number()?
Explain linked server in sql?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
How optimize sql query with multiple joins in sql server?
Can You Use Data Mining Models In Ssrs?
how to create “alternate row colour”?
How to insert data into an existing table?
what are isolation levels? : Sql server database administration
Why use “nolock” in sql server?
Is sql server implemented as a service or an application? : Sql server database administration
What is table valued function and scalar valued functions?
What is relationship? What number of sorts of relationship are there?
What are different replication agents and what's their purpose? : sql server replication
