3

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for power users of Apple hardware and software

DECLARE @MaxTextBeforeCode AS INT = ##MaxTextBeforeCode:int?0##;
DECLARE @MaxTextAfterCode AS INT = ##MaxTextAfterCode:int?0##;

SELECT Id AS [Post Link], Score, CreationDate
FROM Posts
WHERE PostTypeId = 2  -- answers
  AND CHARINDEX('<pre><code>', BODY) < @MaxTextBeforeCode
  AND CHARINDEX('</code></pre>', Body) + LEN('</code></pre>') = LEN(Body)
  AND ClosedDate IS NULL
ORDER BY CreationDate

view current version

edited jun 10 15 Janos

created jun 8 15 rolfl