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 perspective, have you ever created perspective? : sql server analysis services, ssas
Does partitioning ssd reduce performance?
How to verify a user name with sqlcmd tool?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
List out some of the requirements to set up a sql server failover cluster?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What do you understand by recursive stored procedures?
What is the difference between ddl,dml and dcl commands?
What is the use of floor function in sql server?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
How to write a query with an inner join in ms sql server?
Where the sql logs gets stored? : sql server database administration
What is self contained sub query?
What is difference between aggregate and analytic function?
How to create percentile function?