0

Please login or register to vote for this query.

(click on this box to dismiss)

Shows revision comments after removing the automated comments. Real comments, real people, really interesting. Sometimes.

Q&A for peer programmer code reviews

-- Post revision comments
-- Shows revision comments after removing the automated comments.  Real comments, real people, really interesting.  Sometimes.
select Comment, PostId
from PostHistory
where LEN(Comment) > 1 
  AND NOT Comment LIKE 'edited%'
  AND NOT Comment LIKE 'added%'
  AND NOT Comment LIKE 'deleted%'
  AND NOT Comment LIKE 'merging%'
  AND NOT Comment LIKE 'insert%'
  AND NOT Comment LIKE 'Rollback%'
  AND NOT Comment LIKE 'from%'
  AND NOT Comment LIKE 'Proposed%'

fork query

created may 19 11 Adam Davis