How to test for null values?

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,

---

How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE fashion pls help me , thanks in advance surendra

2 Answers   Zensar,

---

Is like operator in sql case sensitive?

0 Answers  

---

Can %notfound return null after a fetch?

0 Answers  

---

---

Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974

5 Answers   Infosys,

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

0 Answers  

---

How to get list of all tables from a database?

0 Answers  

---

Why we use joins in sql?

0 Answers  

---

what is 'mysqlshow'? : Sql dba

0 Answers  

---

Explain the advantages and disadvantages of stored procedure?

0 Answers  

---

In a table only one column how to update rows

5 Answers   Microsoft,

---