What is difference between standardization and normalization?

0 Answers  

---

what is bit data type? and what are the information that can be stored inside a bit column?

2 Answers  

---

What is your recommendation for a query running very slow? : sql server database administration

0 Answers  

---

How to find tables without indexes?

0 Answers  

---

When do u use clustered index and non-clustered index?

3 Answers   IBM,

---

---

How exceptions can be handled in sql server programming?

0 Answers  

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

4 Answers   Credit Suisse, GCU, Symphony, TCS,

---

What are audit control procedures?

0 Answers   Ernst Young, Thomson Reuters,

---

Difference between Function and Stored Procedure?

9 Answers   C1 India, NA,

---

what are cursors? : Sql server database administration

0 Answers  

---