1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
| CREATE function [dbo].[SplitStr]
(
@SourceStr nvarchar(4000),
@Split nvarchar(1)
)
returns @temp table (Result nvarchar(4000))
as
begin
declare @ch as nvarchar(4000)
set @SourceStr=@SourceStr+@Split
if(CHARINDEX(@Split,@SourceStr,1)<=0)
begin
insert @temp values(@SourceStr)
return
end
while(@SourceStr<>N'')
begin
set @ch=LEFT(@SourceStr,CHARINDEX(@Split,@SourceStr,1)-1)
insert @temp values(@ch)
set @SourceStr=STUFF(@SourceStr,1,CHARINDEX(@Split,@SourceStr,1),N'')
end
return
end
--select * from splitstr(N'表白怕被拒绝？,拒绝了连朋友都做不成？,那就别表白了,还可以做朋友,做个朋友还可以借钱,借了钱再表白,表白被拒绝了,朋友做不成了,那就不用还钱了,(///▽///)',',')
GO
|
