Answer Posted / harsha

Yes We can have multiple SP's with same name.This is called
overloading a Procedure with different parameters.
e.g. CREATE PROCEDURE COMPUTE_AREA (LENGTH IN NUMBER,
WIDTH IN NUMBER);
CREATE PROCEDURE COMPUTE_AREA (LENGTH IN NUMBER,
WIDTH IN NUMBER
UNITS IN NUMBER);

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

979

---

What is the difference between delete, truncate and drop command?

1138

---

What is case function?

1034

---

What are the different types of tables in sql?

998

---

What are the rules to be applied to nulls whilst doing comparisons?

1321

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7320

---

What are the types of join in sql?

1095

---

Why we use stored procedure instead of query?

997

---

What is sqlservr exe?

973

---

Can a commit statement be executed as part of a trigger?

1047

---

What is date functions?

1024

---

How do I quit sql?

949

---

what is the difference between primary key and unique key? : Sql dba

1034

---

List out the acid properties and explain?

949

---

What is the difference between Union and Union all. Which is faster.

1401

---