Where are magic tables stored ? Is it in the same database where it is created ?

4 Answers  

---

Can we use having clause without group by?

0 Answers  

---

What is recompile sql server?

0 Answers  

---

What is dbcc command in sql server?

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  

---

What is Extended user-defined?

0 Answers  

---

Can we add an identity column to decimal datatype?

0 Answers  

---

what is difference between having and where clause ?

3 Answers  

---

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

0 Answers  

---

what is trigger . hw will it use them

2 Answers   TCS,

---

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

1 Answers   Logitech, Mphasis,

---

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,

---