Answer Posted / sandeep modapathi

Hi all
Gopi Muluka is right... but here I'm posting one different
thing.. ie the out put will be like this

Only two columns

It uses a function for concatination

CityID CityName
1 SAN DIEGO
2 SAN FRANCISCO
3 CHICAGO
4 NEW YORK CITY


CREATE FUNCTION DBO.GROUP_CONCAT(@CITYID VARCHAR(100))
RETURNS VARCHAR(8000)
AS
BEGIN
DECLARE @STRING VARCHAR(8000)
SET @STRING=''
SELECT @STRING=@STRING+' ' +CITYNAME FROM CITY
WHERE CITYID=@CITYID ORDER BY CONTINUATIONID
RETURN LTRIM(@STRING)
END

select distinct CITYID,dbo.GROUP_CONCAT(CITYID)as CityName
from city

Explain what are the restrictions that views have to follow? : SQL Server Architecture

1056

---

Explain the cursor lock types?

1063

---

What are the types of joins in sql?

1133

---

Mention the different types of triggers?

1124

---

What is exclusive locks?

968

---

How many database files are there in sql server 2000?what are they?

1057

---

What are number line correlation administrators will use while working with a subquery?

1181

---

How to create user defined functions with parameters?

1243

---

explain different types of backups avaialabe in sql server? : Sql server database administration

979

---

What are the tool windows in sql server management studio? : sql server management studio

1085

---

What is the difference between ddl,dml and dcl commands?

1121

---

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

967

---

How many types of attribute relationships are there? : sql server analysis services, ssas

1088

---

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

1092

---

can an order by clause be used in a creation of a view?

1185

---