22,210
社区成员
发帖
与我相关
我的任务
分享
DECLARE @str NVARCHAR(100)= 'A.123 B.456 C.789 D.321'
PRINT REPLACE(@str,' ',CHAR(10))
ALTER FUNCTION dbo.f_splitstr(@SourceSql NVARCHAR(MAX),@StrSeprate VARCHAR(100))
RETURNS @temp TABLE(F1 VARCHAR(100))
AS
BEGIN
DECLARE @ch AS VARCHAR(100)
SET @SourceSql=@SourceSql+@StrSeprate
WHILE(@SourceSql<>'')
BEGIN
SET @ch=LEFT(@SourceSql,CHARINDEX(@StrSeprate,@SourceSql,1)-1)
INSERT @temp VALUES(@ch)
SET @SourceSql=STUFF(@SourceSql,1,CHARINDEX(@StrSeprate,@SourceSql,1),'')
END
RETURN
END
GO
DECLARE @str NVARCHAR(100)= 'A.123 B.456 C.789 D.321'
SELECT f1 FROM dbo.f_splitstr(@str,' ')