What are the difference between clustered and a non-clustered index?

0 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 command is used to create a table by copying the structure of another table?

7 Answers  

---

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

0 Answers  

---

What will be the maximum number of index per table?

0 Answers  

---

Do you know what are the differences between lost updates and uncommitted dependencies?

0 Answers  

---

List the advantages of using stored procedures?

0 Answers  

---

Tell me about pre-defined functions of sql?

0 Answers   EXL,

---

What are the components of dbms?

0 Answers  

---

How many null values we can have in a unique key field in sql server?

0 Answers  

---

When would you use it?

0 Answers  

---

Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY

5 Answers   TCS,

---