whats new about truncate in sql server 2008?

0 Answers   MedSave Healthcare, Serco,

---

What is built-in function?

0 Answers  

---

Explain foreign key in sql server?

0 Answers  

---

What are sql server functions?

0 Answers  

---

How can I check that whether automatic statistic update is enabled or not?

0 Answers  

---

Can you explain what are various ways to enhance the ssrs report?

0 Answers  

---

How to generate create view script on an existing view?

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 DTS and SSIS?

3 Answers   Allianz,

---

syntax and example for bitmap index in sql???

1 Answers  

---

How to move database physical files in ms sql server?

0 Answers  

---

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,

---