CREATE TABLE #LanguageTags ( TagName NVARCHAR(256) COLLAT...

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

CREATE TABLE #LanguageTags (
  TagName NVARCHAR(256) COLLATE SQL_Latin1_General_CP1_CS_AS
);
INSERT INTO #LanguageTags (TagName)
VALUES
('<abap>'),
('<actionscript>'),
('<actionscript-3>'),
('<ada>'),
('<agda>'),
('<apl>'),
('<applescript>'),
('<arnoldc>'),
('<asm.js>'),
('<assembly>'),
('<autohotkey>'),
('<awk>'),
('<bash>'),
('<basic>'),
('<brainfuck>'),
('<c>'),
('<c#>'),
('<c++>'),
('<c++-cli>'),
('<c++03>'),
('<c++0x>'),
('<c++11>'),
('<c++14>'),
('<c++17>'),
('<c++1z>'),
('<c11>'),
('<c99>'),
('<cfml>'),
('<chuck>'),
('<clojure>'),
('<clojurescript>'),
('<cobol>'),
('<coffeescript>'),
('<common-lisp>'),
('<cql>'),
('<css>'),
('<css3>'),
('<cython>'),
('<d>'),
('<dart>'),
('<delphi>'),
('<delphi-xe>'),
('<dogescript>'),
('<dom>'),
('<ecmascript-6>'),
('<elisp>'),
('<elixir>'),
('<elm>'),
('<erlang>'),
('<f#>'),
('<factor-lang>'),
('<fish-language>'),
('<forth>'),
('<fortran>'),
('<fpga>'),
('<fractals>'),
('<geospatial>'),
('<glsl>'),
('<go>'),
('<google-apps-script>'),
('<groovy>'),
('<haml>'),
('<haskell>'),
('<haxe>'),
('<hdl>'),
('<hlsl>'),
('<html>'),
('<html5>'),
('<hy>'),
('<idris>'),
('<io-language>'),
('<j>'),
('<jade>'),
('<java>'),
('<java-8>'),
('<javascript>'),
('<jquery>'),
('<jsx>'),
('<julia>'),
('<jython>'),
('<kotlin>'),
('<ksh>'),
('<lc-3>'),
('<less-css>'),
('<linq>'),
('<linq-expressions>'),
('<lisp>'),
('<logo>'),
('<lolcode>'),
('<lua>'),
('<m4>'),
('<markdown>'),
('<matlab>'),
('<maxscript>'),
('<maya>'),
('<microdata>'),
('<nim>'),
('<object-pascal>'),
('<objective-c>'),
('<ocaml>'),
('<octave>'),
('<pascal>'),
('<pascal-script>'),
('<pawn>'),
('<perl>'),
('<perl6>'),
('<php>'),
('<php5>'),
('<postscript>'),
('<powershell>'),
('<processing>'),
('<processing.js>'),
('<progress-4gl>'),
('<prolog>'),
('<purescript>'),
('<pyth>'),
('<python>'),
('<python-2.6>'),
('<python-2.7>'),
('<python-3.x>'),
('<qml>'),
('<r>'),
('<racket>'),
('<razor>'),
('<rebol>'),
('<rebol2>'),
('<rpython>'),
('<ruby>'),
('<rust>'),
('<salesforce-apex>'),
('<sass>'),
('<scala>'),
('<scheme>'),
('<scratch>'),
('<scss>'),
('<siebel-escript>'),
('<sinatra>'),
('<smalltalk>'),
('<sml>'),
('<snobol4>'),
('<sputnik>'),
('<sql>'),
('<swift>'),
('<wolfram-mathematica>'),
('<xslt>');

SELECT DISTINCT TOP 100
  p.Id AS [Post Link],
  p.Tags,
  lt.TagName,
  p.CreationDate
FROM 
  Posts AS p
  LEFT JOIN #LanguageTags AS lt
    ON p.Tags LIKE '%' + lt.TagName + '%'

Enter Parameters

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