Use Stuff
SELECT STUFF((SELECT ', ' + [StudentID] FROM YOURTABLE FOR XML PATH('')),1,1,'') as [StudentID]
GO
If your column is not a string then you need to cast
SELECT STUFF((SELECT ', ' + CONVERT(varchar(10), StudentID) FROM Emp2 FOR XML PATH('')),1,1,'') as id
GO