Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

0 Answers  

---

Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 Answers  

---

What is dbcc command in sql server?

0 Answers  

---

What is the difference between push and pull subscription? : sql server replication

0 Answers  

---

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

0 Answers  

---

How to select nth record from a table?

13 Answers   DELL, Microsoft, Ramco,

---

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

---

what is difference between primary key and Unique

8 Answers  

---

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,

---

How to create an index on a view?

0 Answers  

---

What are the differences between char and varchar in ms sql server?

0 Answers  

---

What is acid properties?

0 Answers  

---