Hi Friend, If u use SQLSERVER 2005 u can try like this............ CR

hi,
i have a table called names and field name
select * from names
name
a
b
c
d

i want to display like this
name
a,b,c,d
how it is possible

Regards
Baiju

Question Posted / soorai ganesh

4 Answers
6634 Views
I also Faced
E-Mail Answers

Answer Posted / soorai ganesh

Hi Friend,

If u use SQLSERVER 2005 u can try like this............

CREATE TABLE EMP ( ENAME VARCHAR(25))

INSERT INTO EMP VALUES('Ganesh')
INSERT INTO EMP VALUES('Narendra')
INSERT INTO EMP VALUES('Rinku')
INSERT INTO EMP VALUES('Selvam')
INSERT INTO EMP VALUES('Kirti')

SELECT REPLACE(REPLACE(
( SELECT ENAME AS EmpName FROM EMP FOR XML PATH ('') ) ,'<EmpName>',''),'</EmpName>',',')

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

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

989

How to access the deleted record of an event?

975

What is bcp? When does it use?

869

What is an identity column in insert statements?

966

How to connect of datebase with sql express.?

1049

What stored by the tempdb ? : sql server database administration

1004

What are the different types of subquery?

1095

What is difference between temp table and cte?

959

Why do we use stored procedures in sql server?

894

Can you explain different types of locks in sql server?

910

What is policy management?

932

What is a covering index?

917

How to use linked server?

1083

what method you can use to reduce the overhead of Reporting Services data sources?

233

Does sql server use t sql?

952