Select all posts with tag go

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science

Q&A for scientists using computers to solve scientific problems

DECLARE @tag nvarchar(250)
SET @tag = 'security'

DECLARE @tag2 nvarchar(250)
SET @tag2 = 'r'



Select *
from Posts p
where 
  -- acceptedanswerid is not null and 
  p.postTypeId = 1
AND p.tags like '%<security>%'

--AND p.Tags = '<' + @tag + '>' 
-- OR Tags = '<' + @tag2 + '>'
/*AND (Posts.CreationDate > '2009-11-10' 
AND Posts.CreationDate < '2017-02-11') */

Enter Parameters

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