create function f_split(
@c varchar(2000),
@split varchar(2)
)
returns @t table(col varchar(20))
as
begin
while(charindex(@split,@c)<>0)
begin
insert @t(col) values (substring(@c,1,charindex(@split,@c)-1))
set @c = stuff(@c,1,charindex(@split,@c),'')
end
insert @t(col) values (@c)
return
end
go
--調用函數
declare @tem varchar(50)
select @tem =(select Keyword from PE_Article Where ArticleID={input(0)})
select * from dbo.f_split(@tem,'|')
go