34,591
社区成员
发帖
与我相关
我的任务
分享
select * from [dbo].[SPLIT] (
(select distinct(key4) as key1 from news where key4<>'' and key4 like '%,%' and newsid='0001')
,',')
ALTER FUNCTION [dbo].[SPLIT](@SourceSql VARCHAR(max),@StrSeprate NVARCHAR(10))
RETURNS @temp TABLE(sl NVARCHAR(200))
AS
BEGIN
DECLARE @i INT
SET @SourceSql=RTRIM(LTRIM(@SourceSql))
SET @i=CHARINDEX(@StrSeprate,@SourceSql)
WHILE @i>=1
BEGIN
INSERT @temp VALUES(LEFT(@SourceSql,@i-1))
SET @SourceSql=SUBSTRING(@SourceSql,@i+1,LEN(@SourceSql)-@i)
SET @i=CHARINDEX(@StrSeprate,@SourceSql)
END
INSERT @temp VALUES(@SourceSql)
RETURN
END