如何在SQL Server中分割字符串

SELECt substring(data, 1, CHARINDEX(',',data)-1) col1,substring(data, CHARINDEX(',',data)+1, LEN(data)) col2FROM table