Answer Posted / p.rajasekar

Function:
1.Function Always Return values
2.We can call the function in select Query
3.We can return more than one values using Out put
paramaetes
4.Genrally we can use function as calculatevalues
5.We can insert,update or delte value with the help
function in a select query
Procedure:
1.Procedure doesnot always return value
2.We can't call procedure in Select query
3.We can return more than one value using Out put
parameters in procedure
4.Genarally procudures are using as business logic

What are sql commands?

935

---

what are the security recommendations while using mysql? : Sql dba

1049

---

What is the difference between microsoft access and sql server?

987

---

Explain select statements in sql?

999

---

Is pl sql better than sql?

979

---

What is rank () in sql?

882

---

What is the difference between an inner and outer join?

960

---

what is innodb? : Sql dba

1033

---

which operator is used in query for pattern matching? : Sql dba

947

---

Whis is not false in primary key?

1402

---

What is meant by <> in sql?

893

---

define sql insert statement ? : Sql dba

974

---

How do I start sql profiler?

941

---

Is mariadb a nosql database?

1005

---

how is myisam table stored? : Sql dba

997

---