Return to Answer

make code fit page width

Source Link

edit approved May 31, 2020 at 9:41

1.6k
1
10
21

I'm running something like this:

create table #tmp (line varchar(max)) 

insert into #tmp
exec sp_helptext 'sp_Blitz'

declare @version varchar(50); 

select @version=Left@version = Left(line, CHARINDEX('''',line,CHARINDEX('''',line,1)+1))  
from #tmp  
where line like '%@Version =%' 

set @version = reverse(left(REVERSE(@version),CHARINDEX('''',reverse(@version),2))) 

select replace(@version,'''','')

drop table #tmp

I'm running something like :

create table #tmp (line varchar(max))
insert into #tmp
exec sp_helptext 'sp_Blitz'

declare @version varchar(50);
select @version=Left(line, CHARINDEX('''',line,CHARINDEX('''',line,1)+1)) from #tmp where line like '%@Version =%'
set @version = reverse(left(REVERSE(@version),CHARINDEX('''',reverse(@version),2)))
select replace(@version,'''','')

drop table #tmp

I'm running something like this:

create table #tmp (line varchar(max)) 

insert into #tmp
exec sp_helptext 'sp_Blitz'

declare @version varchar(50); 

select @version = Left(line, CHARINDEX('''',line,CHARINDEX('''',line,1)+1)) 
from #tmp 
where line like '%@Version =%' 

set @version = reverse(left(REVERSE(@version),CHARINDEX('''',reverse(@version),2))) 

select replace(@version,'''','')

drop table #tmp

Source Link

created May 29, 2020 at 14:35

Dominique Boucher

3.3k
11
27

I'm running something like :

create table #tmp (line varchar(max))
insert into #tmp
exec sp_helptext 'sp_Blitz'

declare @version varchar(50);
select @version=Left(line, CHARINDEX('''',line,CHARINDEX('''',line,1)+1)) from #tmp where line like '%@Version =%'
set @version = reverse(left(REVERSE(@version),CHARINDEX('''',reverse(@version),2)))
select replace(@version,'''','')

drop table #tmp