How many columns can exist together per table?

0 Answers   Cap Gemini,

---

What is a sql join?

0 Answers  

---

What is the Difference beween sql server 2005 and sql server 2008

3 Answers   CMC, Hitech,

---

Tell me the difference between clustered and non-clustered index?

0 Answers  

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

0 Answers  

---

---

What happens if the update subquery returns no rows in ms sql server?

0 Answers  

---

Can an entity have two primary keys?

0 Answers  

---

Explain database normalization?

0 Answers  

---

What is collation?

0 Answers  

---

Does transparent data encryption provide encryption when transmitting data across the network?

0 Answers  

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

0 Answers  

---

How do you rebuild an identity column?

0 Answers  

---