substring()函数，charindex()函数

上一篇 / 下一篇 2012-08-30 15:12:37 / 个人分类：数据库

charindex(str1，str2)函数：select charindex('aaa','bbaaacc')查找aaa在bbaaacc中第一次出现的下标位置，应返回3

substring(str，beginindex，endindex)函数：select substring('abcd',2,4),取下标从第二个开始到第四个的字符串[2,4]

---项目应用

declare @str varchar(4000)

declare @spit varchar(10)

declare @spit1 varchar(1024)

declare @guizejieguo varchar(1024)

declare @i int

set @spit='<Source>'

set @spit1='</Source>'

set @i=1

while(@i<=5569)

begin

select @str=rulecontent from [rule] where id=@i

--select substring(@str,1,charindex(@spit,@str,2)-1)

select @guizejieguo=substring(@str,charindex(@spit,@str,2)+8,charindex(@spit1,@str,2)-charindex(@spit,@str,2)-8)

--print @guizejieguo

insert into temp_test(id,name,jiancheng) select id,name,@guizejieguo from [rule] where id=@i and id in (select ruleid from task )

set @i=@i+1

end

TAG: