摘要:
one:declare @s varchar(20)declare @i varchar(20)set @i=''set @s='新会员必须购买350元产品'while PATINDEX ('%[0-9]%', @s)>0begin set @i=@i+substring(@s,PATINDEX ('%[0-9]%', @s),1)set @s=stuff(@s,1,PATINDEX ('%[0-9]%', @s),'')endselect @i--300two:declare @a tabl 阅读全文