What are clustered and non-clustered index?

0 Answers  

---

How to store and query spatial data?

0 Answers  

---

Which language is supported by sql server?

0 Answers  

---

What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

3 Answers   TCS,

---

What is a data collection table?

0 Answers  

---

can any one please send sql quries most used in applications.

2 Answers  

---

What authentication modes does sql server support?

0 Answers  

---

What is query processing?

0 Answers  

---

can foreign key take role of primary key?

5 Answers   CarrizalSoft Technologies, TCS, Villa Marie,

---

How do you use a subquery to find records that exist in one table and do not exist in another?

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,

---

What is an indice?

0 Answers  

---