What are the different types of joins and what does each do?

2 Answers  

---

What is merge?

0 Answers  

---

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

0 Answers  

---

What is a trace frag? Where do we use it?

0 Answers  

---

SQL Server Performance Tuning for Stored Procedures & reducing debugging time?

1 Answers   CarrizalSoft Technologies,

---

What is attribute? : sql server analysis services, ssas

0 Answers  

---

Mention the differences between local and global temporary tables.

0 Answers  

---

What is the syntax for encrypting a column in SQL Server?

0 Answers   MindCracker,

---

Can primary key be null?

0 Answers  

---

What are trace flags and mention a few common trace flags used with sql server?

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 difference between index and primary key?

0 Answers  

---