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
7039 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 the difference between value type and reference type?

992

Can group functions be mixed with non-group selection fields in ms sql server?

999

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1248

What is dbcc updateusage?

1259

How to create percentile function?

159

What are the authentication modes in sql server? How can it be changed?

1193

What is the fillfactor concept in indexes?

1037

What is the usage of sign function?

1178

Explain full-text query in sql server?

1054

What is after dml trigger?

1063

What is ssl in sql server?

1135

What do you mean by authentication modes in sql server?

1137

write an SQL query to list the employees who joined in the month of January?

1742

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

1082

how to define testing of network layers? : Sql server database administration

1026