1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
|
create function findData(@str varchar(500))
returns varchar(50)
as
begin
declare @out varchar(50)
if charindex('value',@str)=0
set @out= 'Aucune valeur'
else
set @out=substring(@str,charindex('value',@str)+len('value')+2,charindex('data',@str,charindex('value',@str))-charindex('value',@str)-len('value')-4)
return @out
end
go
create function findvalue(@str varchar(500))
returns varchar(50)
as
begin
declare @out varchar(50)
if charindex('data',@str,charindex('value',@str))=0
set @out= 'Aucune valeur'
else
set @out=substring(substring(@str,1,len(@str)-1),charindex('data',substring(@str,1,len(@str)-1),charindex('value',substring(@str,1,len(@str)-1)))+len('data')+2,500)
return @out
end
go
declare @value varchar(50),@data varchar(50),@str varchar(500)
SET @str='Key "hkey_classes_root \mime\database\content type\application/x-cnet-vsl" value "extension" data ".vsl"'
SELECT @value=dbo.findvalue(@str),@data=dbo.finddata(@str)
print @value
print @data |
Partager