Download codeblocks as file

0

Please login or register to vote for this query.

(click on this box to dismiss)

https://meta.stackexchange.com/questions/364374/download-codeblocks-as-file

Software Quality Assurance and Testing Meta

Q&A about the site for software quality control experts, automation engineers, and software testers

select id 
     , substring(body,[start code], [end code] - [start code]) [first code block]
from
(
select id
     , body
     , charindex(N'<pre><code>', body) + 11 [start code]
     , charindex(N'</code></pre>', body) [end code]
from posts
where owneruserid = 267099
) data
where [end code]>0

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results