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
6864 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

how to do partition in sqlserver

2476

What are the High-Availability solutions in SQL Server and differentiate them briefly?

1146

What is change data capture (cdc) feature?

1069

Please illustrate physical database architecture? : SQL Server Architecture

988

How to backup encryption key ?

183

What functions can a view be used to performed?

1060

What are the database roles? : sql server security

1189

What is a ddl statement?

914

What is the osql utility?

975

What are the characteristics of modern DBMS?

1092

What is bit data type?

1037

What are the options which must be set to allow the usage of optimistic models?

963

What is cached report?

143

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2753

Which is the latest version of sql server and when it is released?

1113