SQL 用分割符分割数据插入数据库

Begin
    declare @temp table(tbMID int)
    declare @i int
    declare @j int
    declare @splitsign varchar(10)
    declare @ConID int
    declare @SourceID varchar(4000)
set  @SourceID='11085,11113,11352,11364,11395,11396,11558,11629,11651,11665,11710,11711,11737,11738,11739,11748,11790,11821,11823,11824'
--set  @SourceID='11085'
set @ConID=236
    set @splitsign=','
    select @j=len(@SourceID)-len(replace(@SourceID,',',''))
    set @i=charindex(@splitsign,@SourceID)
    -- print @i
    while @j>=1
    begin
        insert @temp values(left(@SourceID,@i-1))
        set @SourceID=substring(@SourceID,@i+1,len(@SourceID)-@i)
        set @i=charindex(@splitsign,@SourceID)
        set @j=@j-1
    end
    if @SourceID<>''
       insert @temp values(@SourceID)
   select * from @temp
   return
End