How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

4 Answers   Credit Suisse, GCU, Symphony, TCS,

---

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

0 Answers   Genpact,

---

What is difference between group by and having?

0 Answers  

---

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

0 Answers  

---

Do you know what is bit data type and whats the information that can be stored inside a bit column?

0 Answers  

---

---

The Difference between 'Count' and 'Count(*)'

13 Answers  

---

What are the restrictions that views have to follow? : SQL Server Architecture

0 Answers  

---

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 Answers   247Customer,

---

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

7 Answers   Value Labs,

---

what is nonclustered index

0 Answers  

---

How do I get to sql server configuration manager?

0 Answers  

---

How each E-R model constructs can be mapped to the relational model?

0 Answers   HCL,

---