what is the differnce between procedure and function?
in both dml operations can work and in procedure through out
parameter you can return value ,then what is the differce?
- 3 Answers
- 6716 Views
- 3i Infotech, I also Faced
- E-Mail Answers
Answer Posted / dinakar
Though Procedure returns a value through OUT parameter, it
cannot be used in SELECCT statement. Whereas a function can
be called in SELECT statement.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a sql trace file?
Why we use stored procedure instead of query?
Why should I use postgresql?
what are the different type of sql's statements ? : Sql dba
what is sp_pkeys? : Transact sql
How do I remove all records from a table?
What is the purpose of normalization?
what happens if you no create privilege in a database? : Sql dba
How do you sort in sql?
Is sql open source?
What is sql clause?
what is the difference between nested subquery and correlated subquery?
Can we commit inside a trigger?
What are schema-level triggers?
Is primary key is clustered index?
