What do you mean by stored procedures? How do we use it?

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,

---

What is rank function in sql?

0 Answers  

---

How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

2 Answers  

---

What is form and report?

0 Answers  

---

---

what is a cursor? : Sql dba

0 Answers  

---

what is log shipping? : Sql dba

0 Answers  

---

What is transaction control language (tcl)?

0 Answers  

---

How to recompile a already made trigger?

2 Answers  

---

Which nosql database is best?

0 Answers  

---

How do you modify a table in sql?

0 Answers  

---

What is Referential Integrity?

3 Answers  

---