What is Difference between StoredProcedure and function?
- 3 Answers
- 7788 Views
- I also Faced
- E-Mail Answers
Answer Posted / prabhu karanam
We can use a function in the select query, but Procedure we
can't use in select query. But the function created with out
parameter, we can't use in select statement. Only in
parameter, we can use.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what are the advantages of sql ? : Sql dba
define sql insert statement ? : Sql dba
what is sql server agent? : Sql dba
how many tables will create when we create table, what are they? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
Is inner join faster than left join?
Does group by remove duplicates?
Is primary key clustered index?
Can delete statement be rollbacked?
Is primary key always clustered index?
Do we need to rebuild index after truncate?
How do I remove duplicates in two columns?
what is bcp? When does it used? : Sql dba
What is the current version of postgresql?
what is collation? : Sql dba
