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 is the primary use of normalization?
What are the two types of exceptions.
Can you select everything, but 1 or 2 fields, without writer's cramp?
How do you update a value in sql?
Why having clause is used in sql?
what are numeric data types? : Sql dba
What is a database? Explain
What is normalisation in sql?
Does truncate require commit?
Do prepared statements prevent sql injection?
what is a tablespace? : Sql dba
Explain what is table in a database?
What is sql key?
What is a nested table in word?
Is hadoop a nosql?
