Find questions contain tag "polls"

0

Please login or register to vote for this query.

(click on this box to dismiss)

SET @TargTags = LTRIM (RTRIM (@TargTags) );

Raspberry Pi

Q&A for users and developers of hardware and software for Raspberry Pi

-- Find questions contain tag "polls"
-- SET     @TargTags   = LTRIM (RTRIM (@TargTags) );

SELECT  TOP 5000
    Q.Id            
  , Q.Tags
  , Q.Score
  ,  CONVERT (VARCHAR(10), Q.Creationdate, 112)  AS [Date Asked]
  , Q.AnswerCount   AS [Num Answers]

FROM        Posts AS Q
WHERE       Q.PostTypeId = 1 -- Question
AND         Q.ClosedDate IS NULL
AND         Q.Tags like '%<python>%'
AND         Len(Q.body)>5
ORDER BY    Q.body DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results