What is Difference between StoredProcedure and function?
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
how do you know the version of your mysql server? : Sql dba
explain the advantages and disadvantages of stored procedure? : Sql dba
Is it important to partition hard disk?
How do I run a sql query in pgadmin 4?
How do I count duplicates in sql?
what is the difference between truncate and drop statements? : Sql dba
How do I pipe the output of one isql to another?
What is a primary key sql?
How do I know if I have sql express or standard?
Can a table have no primary key?
What are the two virtual tables available at the time of database trigger execution?
How do I turn a list into a table?
What is a trigger word?
Can we join tables without foreign key?
How to add a column ‘salary’ to a table employee_details?