DECLARE @StudentList VARCHAR(1000)
SET @StudentList = ''

SELECT @StudentList = @StudentList + CAST(StudentID AS VARCHAR(10)) + ', '
FROM yourtablename
WHERE teacherid = @teacherid

SET @Students = LEFT(@StudentList, LEN(RTRIM(@StudentList)) - 1)