一段SQL脚本

create table gc (col1 char (10))
drop table gc

---------------------------
--处理参数
declare @str varchar(100)
select @str='1,2,3,4,5'

--插入处理
declare @s varchar(8000)
select @s='select '
 +replace(@str,',',' union all select ')

exec('insert into gc (col2)  '+@s+'')
-=-------------------------

create function f_splitstr(@SourceSql varchar(8000),@StrSeprate varchar(10))
returns @temp table(F1 varchar(100))
as
begin
 declare @i int
 set @SourceSql=rtrim(ltrim(@SourceSql))
 set @i=charindex(@StrSeprate,@SourceSql)
 while @i>=1
 begin
  insert @temp values(left(@SourceSql,@i-1))
  set @SourceSql=substring(@SourceSql,@i+1,len(@SourceSql)-@i)
  set @i=charindex(@StrSeprate,@SourceSql)
 end
 if @SourceSql<>''
    insert @temp values(@SourceSql)
 return
end
--执行
select * from dbo.f_splitstr('01,02,03',',')