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
How can delete duplicate records in cte in sql server?
What is implicit cursors?
What is difference between clustered and non clustered index?
Disadvantages of the indexes?
what are the new features introduced in sql server 2000? : Sql server database administration
What is the difference between coalesce() & isnull()?
What does set rowcount do?
which backup strategy you are following at ur company
What is a deadlock and what is a live lock?
Explain the benefits of user-defined functions?
How to manipulate data from one table to another table ?
What is the difference between the application object and session object?
What is equi join with example?
What are the types of indexes?
What is partition in sql server?