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

Explain following error properties?

995

What is the contrast between sql and pl/sql?

1115

How network traffic be reduced by using the stored procedure?

1087

What is a DBMS, query, SQL?

1030

What do you understand by the denormalisation?

936

How efficient you are in oracle and SQL server?

1128

What are the approximate numeric data types?

908

What is extent? Types of extents?

1159

What is subreport?

141

What is a fan-out query in SQL Azure?

121

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2048

How do you make a trace?

998

What is the Control Flow in SSIS

1073

What is view in sql?

882

What are sub reports?

201