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
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
What is sql server replication? : sql server replication
How to create user defined functions with parameters?
What are the steps you must follow to hide sql server instances?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
What is BCNF? How is it better than 2NF & 3NF?
How would we use distinct statement? What is its use?
What is @@error in sql?
Define left outer join?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
List the different index configurations possible for a table?
what does the automatic recovery do? : Sql server administration
Explain what is it unwise to create wide clustered index keys?
Explain system functions or built-in functions? What are different types of system functions?
Is mysql the same as sql server?
What are sp_configure commands and set commands?