sql 把字符创分割成两个字符串
使用指定的字符分割字符串。
思路:1,先计算出指定的分割字符在字符串中的索引,
2.然后再分割字符串。
sql代码如下:
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
1 declare @strorder nvarchar(200)
2 declare @ismulorder int
3 declare @firstOrder nvarchar(200)
4 declare @secondOrder nvarchar(200)
5
6 set @strorder='LastModifyDate Desc,OurPrice Asc'
7
8 select CHARINDEX(',',@strorder,0)
9 --select LEN(@strorder)
10 --select SUBSTRING(@strorder,0,CHARINDEX(',',@strorder,0))
11 --select SUBSTRING(@strorder,CHARINDEX(',',@strorder,0)+1,LEN(@strorder))
12 set @ismulorder=CHARINDEX(',',@strorder,0)
13 if @ismulorder>0
14 begin
15 set @firstOrder ='p.'+SUBSTRING(@strorder,0,CHARINDEX(',',@strorder,0))
16 set @secondOrder='p.'+SUBSTRING(@strorder,CHARINDEX(',',@strorder,0)+1,LEN(@strorder))
17 set @strorder=@firstOrder+','+@secondOrder
18 end
19
20
21 select @strorder
2 declare @ismulorder int
3 declare @firstOrder nvarchar(200)
4 declare @secondOrder nvarchar(200)
5
6 set @strorder='LastModifyDate Desc,OurPrice Asc'
7
8 select CHARINDEX(',',@strorder,0)
9 --select LEN(@strorder)
10 --select SUBSTRING(@strorder,0,CHARINDEX(',',@strorder,0))
11 --select SUBSTRING(@strorder,CHARINDEX(',',@strorder,0)+1,LEN(@strorder))
12 set @ismulorder=CHARINDEX(',',@strorder,0)
13 if @ismulorder>0
14 begin
15 set @firstOrder ='p.'+SUBSTRING(@strorder,0,CHARINDEX(',',@strorder,0))
16 set @secondOrder='p.'+SUBSTRING(@strorder,CHARINDEX(',',@strorder,0)+1,LEN(@strorder))
17 set @strorder=@firstOrder+','+@secondOrder
18 end
19
20
21 select @strorder
1,关键函数。charindex,substring,len,
额外函数:right,left