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

0 Answers  

---

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,

---

Explain the properties of subqueries in sql server?

0 Answers  

---

List the different index configurations possible for a table?

0 Answers  

---

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  

---

---

What is the difference between DataRow.Delete() and DataRow.Remove()?

0 Answers  

---

What are the properties of the relational tables?

0 Answers  

---

why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 Answers  

---

is there more the two primary key in a single table?

26 Answers   Eforce, Systematix,

---

how you can list all the tables in a database?

0 Answers  

---

What is normalization? Explain its different types?

0 Answers   GE, Maveric,

---

What are the dmvs?

0 Answers  

---