Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 6857 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
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
what is the difference between Tabular and Matrix report?
What is the use of sql profiler in sql server 2012?
In which sql server version report builder introduced?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What is RAID? What are the different types of RAID configurations?
Why I am getting this error when renaming a database in ms sql server?
What is subquery explain with example?
How to create sub reports?
Which is faster statement or preparedstatement?
What is the recovery model? List the types of recovery model available in sql server?
How to make remote connection in database?
Explain what is the function of sql server agent windows service?
What is lock escalation and what is its purpose?
What according to you is the difference between mysql and sql server performance?
