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
6878 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 set nocount on and what is set nocount off?

937

Explain about unique identifier data type in sql server?

922

What are the 2 types of classifications of constraints in the sql server?

1127

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1139

How to use go command in "sqlcmd"?

1213

Explain different types of self contained sub query?

1051

Why we use functions in sql server?

1085

What is a livelock?

973

Explain something about security and SQL Azure?

134

What to check if a User database is locked?

1075

What is self contained scalar sub query?

976

what's the difference between a primary key and a unique key? : Sql server database administration

959

how can you check the level of fragmentation on a table? : Sql server administration

988

What area unit the various kinds of info compression introduced in sql server 2008?

1100

what is difference between NULL and ISNULL in SQL Server 2008?

1020