select SUBSTRING('123,abcdefg',charindex(',','123,abcdefg',0)+1,LEN('123,abcdefg')-charindex(',','123,abcdefg',0))
select SUBSTRING('123,abcdefg',0,charindex(',','123,abcdefg',0))
select SUBSTRING('123,abcdefg',charindex(',','123,abcdefg',0)+1,LEN('123,abcdefg')-charindex(',','123,abcdefg',0))
select SUBSTRING('123,abcdefg',0,charindex(',','123,abcdefg',0))
转载于:https://www.cnblogs.com/kunEssay/p/5726672.html