Which tcp/ip port does sql server run?

0 Answers  

---

What is the usage of the distinct keyword?

0 Answers  

---

Can a key be both primary and foreign?

0 Answers  

---

What is the difference between DELETE and TRUNCATE?

15 Answers   Johns Hopkins University, Tech Mahindra,

---

Is inner join faster than left join?

0 Answers  

---

What are actual parameters and formal parameters?

0 Answers  

---

what are the different functions in sorting an array? : Sql dba

0 Answers  

---

What is sql and also describe types of sql statements?

0 Answers  

---

Difference between aggregate function and analytical function?

3 Answers   Metric Stream,

---

i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75

12 Answers   IBM,

---

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 do I view an execution plan in sql?

0 Answers  

---