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;