how many columns can be used for creating index? : Sql dba

0 Answers  

---

how to create a table index in mysql? : Sql dba

0 Answers  

---

What are the most important ddl statements in sql?

0 Answers  

---

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

---

Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?

5 Answers   HSBC,

---

What is sql partition function?

0 Answers  

---

What is a 'instead of trigger'?

3 Answers   Eenadu, TCS,

---

What is materialized view. What are different methods of refresh?

0 Answers  

---

What do you mean by stored procedures?

0 Answers  

---

Which is faster union or join?

0 Answers  

---

How do I run sql?

0 Answers  

---

Difference between IN and EXISTS

4 Answers   Nous, Polaris,

---