字符串的截取

我懂了

declare @mm1 varchar(50)
declare @nn1 varchar(50)
set @nn1=''
set @mm1='10011002100310041005'
set @nn1=substring(@mm1,1,4)
select @nn1
set @nn1=substring(@mm1,5,4)
select @nn1
set @nn1=substring(@mm1,9,4)
select @nn1
set @nn1=substring(@mm1,13,4)
select @nn1
set @nn1=substring(@mm1,17,4)
select @nn1

用这种方法可以把截取的字符串直接赋给变量@s1@s2@s3@s4@s5，供你下一步使用
create procedure sub
 @mm varchar(20)
,@str1 varchar(10) output
,@str2 varchar(10) output
,@str3 varchar(10) output
,@str4 varchar(10) output
,@str5 varchar(10)output
as
begin      
      set @str1=substring(@mm,1,4)
      set @str2=SUBSTRING(@mm,5,4)
      set @str3=SUBSTRING(@mm,9,4)
      set @str4=SUBSTRING(@mm,13,4)
      set @str5=SUBSTRING(@mm,17,4)
      
end
declare @s1 varchar(10)
       ,@s2 varchar(10)
       ,@s3 varchar(10)
       ,@s4 varchar(10)
       ,@s5 varchar(10)
execute sub '10011002100310041005',@str1=@s1 output,@str2=@s2 output,@str3=@s3 output,@str4=@s4 output,@str5=@s5 output

111