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  

---

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 Answers  

---

What is sql server replication? : sql server replication

0 Answers  

---

what is the system function to get current user's user id? : Sql server database administration

0 Answers  

---

Rate yourself in .NET and SQL ?

1 Answers   Cognizant, HCL, SunGard,

---

What is subquery in sql?

0 Answers  

---

What is the difference between inner join and equi join?

0 Answers  

---

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

0 Answers  

---

Give the query of getting last two records from the table in SQL SERVER?

0 Answers   Petranics Solutions,

---

What is the order by used for?

0 Answers  

---

What command do we use to rename a db?

5 Answers   IBM,

---

What is the use of tempdb? What values does it hold?

0 Answers   Abacus,

---