0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those using, extending or developing Emacs

SELECT TOP 20
  Q.Id as [Post Link]
  ,Q.Body
  ,Q.CreationDate
FROM Posts Q
WHERE
  Q.PostTypeId = 1 -- Question
  AND Q.Score > 0
  AND Q.Tags COLLATE Latin1_General_BIN LIKE '%aws%'
  AND Q.Body COLLATE Latin1_General_BIN LIKE '%AWS_SECRET_ACCESS_KEY%'
  AND UPPER(Q.Body) COLLATE Latin1_General_BIN NOT LIKE '%XXXXX%'
--ORDER BY Q.CreationDate
;

view current version

edited oct 1 22

created oct 1 22 anonymous