Shankar Chavan
Showing posts with label
SQL
.
Show all posts
Showing posts with label
SQL
.
Show all posts
Friday, 27 December 2013
SQL-Convert all rows of a column into comma separated values
SELECT STUFF((SELECT ',' + name
FROM Sys.columns where object_id=OBJECT_ID('tblName')
FOR XML PATH('')) ,1,1,'') AS Txt
Home
Subscribe to:
Posts (Atom)