Answer Posted / pankaj mehra

Well the main difference between procedures and function is
that the procedure may/may not return any value.it can
return more than one value also.
but functions can return only one value at a time and it
must have return keyword inside the function

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

909

---

how can I make a script that can be bi-language (supports english, german)? : Sql dba

954

---

how to use like conditions? : Sql dba

1051

---

How to combine two stored procedures in sql?

1135

---

What is the best sql course?

944

---

What does count (*) mean?

878

---

What is delimiter sql?

935

---

What is string join?

946

---

Write the command to remove all players named sachin from the players table.

1131

---

what are the authentication modes in sql server? : Sql dba

1015

---

How many unique keys can a table have?

969

---

Which type of cursor is used to execute the dml statement?

909

---

Can a varchar be a primary key?

963

---

How to read xml file in oracle pl sql?

868

---

Explain the difference in execution of triggers and stored procedures?

981

---