存储过程中使用charindex切分字符串:
- declare @s varchar(100)
- set @s='ren,de,gens'
- declare @position smallint
- declare @length1 varchar(50);
- declare @length2 varchar(50);
- declare @length3 varchar(50);
- set @position=charindex(',',@s)
- set @length1=substring(@s,1,@position-1)
- set @s=right(@s,(len(@s)-@position))
- set @position=charindex(',',@s)
- set @length2=substring(@s,1,@position-1)
- set @s=right(@s,(len(@s)-@position))
- select @length1,@length2,@s