Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / malkeet kaur
1)functions may or may not have return type but procedure doesn't have return type
2)functions are called from select statement but procedure can not called from select statement
3)fuctions are used when some data is passed to calling environment but procedure is used
when some processing to be done
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are all types of user defined functions?
which types of join is used in sql widely? : Sql dba
how to use myisamchk to check or repair myisam tables? : Sql dba
What is sql performance tuning?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
How do you change a value in sql?
when is the use of update_statistics command? : Sql dba
What is the difference between sql, mysql and sql server?
Why are aggregate functions called so?
What is the difference between functions, procedures, and packages in pl/sql?
Does a primary key have to be a number?
Explain cursor types?
What is a clob in sql?
What is crud sql?
Can a procedure in a package be overloaded?
