tp框架做餐饮网站/怎样推广自己的app
利用PARSENAME函数分割字符串
DECLARE @str nvarchar(50)=N'NBA||湖人||老詹||MVP';
SELECT PARSENAME(REPLACE(@str,'||','.'),4), PARSENAME(REPLACE(@str,'||','.'),3), PARSENAME(REPLACE(@str,'||','.'),2), PARSENAME(REPLACE(@str,'||','.'),1)
利用PARSENAME函数分割字符串
DECLARE @str nvarchar(50)=N'NBA||湖人||老詹||MVP';
SELECT PARSENAME(REPLACE(@str,'||','.'),4), PARSENAME(REPLACE(@str,'||','.'),3), PARSENAME(REPLACE(@str,'||','.'),2), PARSENAME(REPLACE(@str,'||','.'),1)