In this article I am trying to demonstrate, how to generate comma separated value (CSV) from a particular table objects fields.
So I am going to demonstrate it as step by step that we can understand it properly.
Step-1 [ The base Table Objects ]
CREATE TABLE #tbl_Student
(Roll INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
Sname VARCHAR(50) NOT NULL)
Step-2 [ Inserting Records ]
INSERT INTO #tbl_Student
(Sname)
VALUES ('Joydeep'),
('Sukamal'),
('Sangram'),
('Tuhin'),
('Sudip'),
('Bhola')
SELECT * FROM #tbl_Student
Roll Sname
1 Joydeep
2 Sukamal
3 Sangram
4 Tuhin
5 Sudip
6 Bhola
Step-3 [ Creating CSV format ]
SELECT SUBSTRING((SELECT ',''' + a.Sname+''''
FROM #tbl_Student a
ORDER BY a.Sname
FOR XML PATH('')),2,200000) As RESULT;
RESULT
'Bhola','Joydeep','Sangram','Sudip','Sukamal','Tuhin'
It is easy but very useful.
Hope you like it.
Posted by: MR. JOYDEEP DAS
