0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

/**
 * @Author Phrancis (Code Review.SE)
 *
 * The goal of this query is to have an easy reference 
 * for users who wish to use specific sets of tags in their SEDE queries.
 * The queries below each create a temporary table that can easy be copied
 * into other queries for your convenience and enjoyment.
 */

/* 1- ALL TAGS */

CREATE TABLE #AllTags (Name VARCHAR(100));
GO
INSERT INTO #AllTags(Name)
  SELECT DISTINCT 
    TagName
  FROM Tags;
GO

-- SELECT Name FROM #AllTags;

/* 2- LANGUAGE-SPECIFIC TAGS */

CREATE TABLE #LanguageTags (Name VARCHAR(100));
GO
INSERT INTO #LanguageTags 
VALUES
  ('.htaccess'),
  ('akka'),
  ('asp.net-mvc-3'),
  ('backbone.js'),
  ('bacon.js'),
  ('bdd'),
  ('beautiful-soup'),
  ('bluetooth'),
  ('brainfuck'),
  ('c'),
  ('c#'),
  ('c++'),
  ('c++11'),
  ('c++14'),
  ('casper.js'),
  ('cellular-automata'),
  ('cfml'),
  ('coffeescript'),
  ('css3'),
  ('csv'),
  ('cython'),
  ('dapper'),
  ('ddd'),
  ('elixir'),
  ('express.js'),
  ('gradle'),
  ('grunt.js'),
  ('gwt'),
  ('http'),
  ('hy'),
  ('ios'),
  ('jade'),
  ('javascript'),
  ('jms'),
  ('jquery'),
  ('jsf'),
  ('jsp'),
  ('jstl'),
  ('jsx'),
  ('julia'),
  ('knockout.js'),
  ('laravel'),
  ('ldap'),
  ('less-css'),
  ('libgdx'),
  ('linked-list'),
  ('linq'),
  ('linux'),
  ('lisp'),
  ('logo'),
  ('lua'),
  ('makefile'),
  ('math-expression-eval'),
  ('matlab'),
  ('maya'),
  ('memory-optimization'),
  ('mixins'),
  ('monads'),
  ('mongodb'),
  ('mpi'),
  ('ms-access'),
  ('mvc'),
  ('mvp'),
  ('mysql'),
  ('node.js'),
  ('numba'),
  ('numpy'),
  ('objective-c-runtime'),
  ('ocaml'),
  ('odoo'),
  ('opencv'),
  ('owin'),
  ('paper.js'),
  ('parsec'),
  ('php'),
  ('php5'),
  ('phpunit'),
  ('powershell'),
  ('propel'),
  ('pygame'),
  ('python'),
  ('python3'),
  ('qt'),
  ('r'),
  ('rc'),
  ('rebol'),
  ('regex'),
  ('require.js'),
  ('rhino'),
  ('ruby'),
  ('ruby-on-rails'),
  ('rust'),
  ('sas'),
  ('scala'),
  ('scheme'),
  ('sfml'),
  ('sse'),
  ('stl'),
  ('svg'),
  ('system.reactive'),
  ('titanium'),
  ('tkinter'),
  ('t-sql'),
  ('twitter-bootstrap'),
  ('udp'),
  ('underscore.js'),
  ('unity3d'),
  ('winapi'),
  ('windows'),
  ('wolfram-mathematica'),
  ('xslt');
GO

-- SELECT Name FROM #LanguageTags;

/* 3- GENERAL TAGS */

CREATE TABLE #GeneralTags (Name VARCHAR(100));
GO
INSERT INTO #GeneralTags 
VALUES
  ('active-record'),
  ('algorithm'),
  ('animation'),
  ('api'),
  ('array'),
  ('asynchronous'),
  ('authentication'),
  ('base64'),
  ('batch'),
  ('beginner'),
  ('binary-search'),
  ('bitset'),
  ('cache'),
  ('category'),
  ('chess'),
  ('child-process'),
  ('circular-list'),
  ('classes'),
  ('codeigniter'),
  ('compression'),
  ('computational-geometry'),
  ('concurrency'),
  ('coordinate-system'),
  ('cryptography'),
  ('data-structures'),
  ('depth-first-search'),
  ('design-patterns'),
  ('device-driver'),
  ('dictionary'),
  ('directory'),
  ('dom'),
  ('dsl'),
  ('dynamic-programming'),
  ('e-commerce'),
  ('email'),
  ('finance'),
  ('firefox-addon'),
  ('form'),
  ('framework'),
  ('ftp'),
  ('game'),
  ('generator'),
  ('generics'),
  ('google-app-engine'),
  ('graph'),
  ('gui'),
  ('heap'),
  ('hibernate'),
  ('higher-order-functions'),
  ('https'),
  ('ienumerable'),
  ('image'),
  ('inheritance'),
  ('integer'),
  ('io'),
  ('iterator'),
  ('lambda'),
  ('library'),
  ('locking'),
  ('macros'),
  ('markdown'),
  ('minecraft'),
  ('mobile'),
  ('mocks'),
  ('music'),
  ('networking'),
  ('null'),
  ('numerical-methods'),
  ('observable'),
  ('opengl'),
  ('optimization'),
  ('pagination'),
  ('parsing'),
  ('pdo'),
  ('plugin'),
  ('primes'),
  ('processing'),
  ('producer-consumer'),
  ('programming-challenge'),
  ('random'),
  ('reinventing-the-wheel'),
  ('role-playing-game'),
  ('salesforce'),
  ('serialization'),
  ('servlets'),
  ('session'),
  ('set'),
  ('signal-handling'),
  ('signal-processing'),
  ('singleton'),
  ('state'),
  ('state-machine'),
  ('statistics'),
  ('stored-procedure'),
  ('strings'),
  ('synchronization'),
  ('template'),
  ('template-meta-programming'),
  ('thread-safety'),
  ('timeout'),
  ('twitter'),
  ('type-safety'),
  ('unit-testing'),
  ('user-interface'),
  ('variant-type'),
  ('vectorization'),
  ('web-services');
GO

-- SELECT Name FROM #GeneralTags;

fork query

edited jun 12 15 Phrancis

created jun 11 15 jon.doe16279