Phrancis
|
Registered User
|
- IF/ELSE branching using temp table(s)
- DECLARE @shell INT = 236, @sh INT = 1101, @bash INT = 133;
- SELECT Tags.TagName, Tags.Count AS QuestionCount, SUM(Pos...
- WITH QuestionData AS ( SELECT t.TagName, QuestionCount = ...
- Versioned Language Tags (Java, C#, Python)
- SELECT COUNT(Id) FROM POSTS AS q WHERE CLOSEDDATE IS NOT...
- SELECT Id AS [Post Link], AcceptedAnswerId, CreationDate,...
- obtain all closed questions with score < -3
- obtain all closed questions with score < -3
- /* Best of Code Review 2016 - Best Newcomer (answer) cate...
- Best of Code Review 2016 - Best Newcomer (answer) category
- Best of Code Review 2016 - Best Newcomer (question) category
- Recent 1000 users
- Select posts without specific tag list
- SELECT TOP 100 P.Id AS [Post Link] , P.Tags , P.CreationD...