截取sql 第一次出现字符之前的数据
(select left( a.ChangeProductName,charindex(',', ChangeProductName)-1)) as ChangeProductName ,
(select left( a.ChangeProductName,charindex(',', ChangeProductName)-1)) as ChangeProductName ,
转载于:https://www.cnblogs.com/dullbaby/p/5485043.html