What is the STUFF function and how does it differ from the REPLACE function?

2 Answers  

---

What is the primary use of the model database?

0 Answers  

---

how can i view structure of table in sql server? tell me that query.

10 Answers  

---

How to list all triggers in the database with sys.triggers in ms sql server?

0 Answers  

---

How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com

35 Answers   Oracle, Scend, TechInfini,

---

---

WHAT OPERATOR PERFORMS PATTERN MATCHING?

2 Answers   CarrizalSoft Technologies, CTS,

---

What are the parts of a function?

0 Answers  

---

What is a view and what are its advantages?

0 Answers  

---

Do you know what are various aggregate functions that are available?

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 the difference between substr and charindex in the sql server?

0 Answers  

---

Define clusters?

0 Answers  

---