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


Please Help Members By Posting Answers For Below Questions

How can delete duplicate records in cte in sql server?

606


What is implicit cursors?

629


What is difference between clustered and non clustered index?

604


Disadvantages of the indexes?

656


what are the new features introduced in sql server 2000? : Sql server database administration

620






What is the difference between coalesce() & isnull()?

631


What does set rowcount do?

602


which backup strategy you are following at ur company

1834


What is a deadlock and what is a live lock?

654


Explain the benefits of user-defined functions?

622


How to manipulate data from one table to another table ?

627


What is the difference between the application object and session object?

685


What is equi join with example?

651


What are the types of indexes?

676


What is partition in sql server?

617