Categories
Advance SQL
(20)
Interview QA
(4)
Knowledge Queries
(34)
SQL BASIC
(12)
SQL Functions
(2)
SQL Queries
(4)
Saturday 18 May 2013
Sql server:Column data in comma seprated string
Column data in comma seprated string
Sql server:Column data in comma seprated string
A sql sever provide you a inbuild function
COALESCE Function
to select a Column data of a table,to a comma seprated string.
By using bellow query we can select column data in comma separated string.
Example::
create table
#temp(id
int
,names
varchar(50)
)
insert into
#temp(id,names)
values
(1,'SandipG')
insert into
#temp(id,names)
values
(1,'Aditya')
insert into
#temp(id,names)
values
(1,'Ajit')
insert into
#temp(id,names)
values
(1,'Chandu')
A query for select column data in comma separated string::
DECLARE
@CommaSeperatedValues
VARCHAR
(MAX)
SELECT
@CommaSeperatedValues =
COALESCE
(@CommaSeperatedValues+',' , '') + names
FROM
#temp
print
@CommaSeperatedValues
1 comment:
Anonymous
20 May 2013 at 15:48
you done a good work
Reply
Delete
Replies
Reply
Add comment
Load more...
if you have any doubt any suggestions do comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
you done a good work
ReplyDelete