Posts with SQL Fiddle links but no SQL tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT Id, Tags, Title, Body
INTO #tmp
FROM POSTS
WHERE PostTypeId = 1 
  AND CreationDate > '2014-01-01' 
  AND Body LIKE('%sqlfiddle.com%')

SELECT Id as [Post Link], Tags
FROM #tmp
WHERE tags not like('%sql%') and 
      tags not like('%oracle%')

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results