DECLARE @chrString as varchar(200) select @chrString=@chrString + '

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 / kulwinder

4 Answers
7019 Views
I also Faced
E-Mail Answers

Answer Posted / kulwinder

DECLARE @chrString as varchar(200)

select @chrString=@chrString + ',' + Name from Names

? @chrString

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is database replicaion? : Sql server database administration

1268

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

1087

role of sql sever 2005 in database rather than any other database

1987

How to send email from database?

1070

Explain the concept of view and Types of views in SQL server?

1034

Introduction of rollup clause using sum and group by clause?

1010

Does sql server use java?

1127

Do you know what is difference between stored procedure and user defined function?

1147

what is sql server? : Sql server database administration

1041

What is the difference between system objects and user objects?

1211

What is the Disadvantage of indexed sequential file.

1126

How to add a new dsn with the odbc driver for sql server?

1112

How do I create a partition table in sql server?

1181

Explain an automatic checkpoint

1012

What are the diifferences between the ms sql server vs mysql?

1234