讨厌：

Nasty:

SELECT LEFT(CsvData, CHARINDEX(',', CsvData)), RIGHT(CsvData, LEN(CsvData) - CHARINDEX(',', CsvData)) FROM MyTable

会这样做，但你***不要像那样存储你的数据完全没有。

Will do it, but you are much better off not storing your data like that at all.