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

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

943

---

What is bulk collect in pl sql?

1038

---

what is the functionality of the function htmlentities? : Sql dba

901

---

What is the difference between a primary key and a unique key?

1011

---

What are transaction and its controls?

978

---

How do I create a sql database?

959

---

what is 'mysqlshow'? : Sql dba

982

---

what is schema? : Sql dba

996

---

What is the advantage of index in sql?

921

---

How do I run a script in sql developer?

904

---

What are system versioned tables?

976

---

Do we need commit after truncate?

1043

---

How many databases can sql express handle?

948

---

What does truncate mean in sql?

973

---

How can I delete duplicate rows?

974

---