Skip to content

Denham Coder

It's all go here. SQL Server, NoSQL, TSQL, Cypher, C#, Javascript, Python, Powershell, TDD, Unit Testing, Structured Coding Methodologies, Azure Cloud, Containers, Devops, I could keep going

  • Home
  • About

Month: November 2018

TSQL Tips – Window Functions

November 9, 2018

I use window functions a lot however; I often find myself having to remind myself on certain syntaxes or the different outputs between two functions. The following code snippet is used just as a reminder on what is available and is not a complete exhaustive list. The following code consists of three different CTES. Here … More TSQL Tips – Window Functions

TSQL Tips – Window Functions

TSQL Tips – VALUES in FROM Clause

November 9, 2018

There are occasions when testing TSQL that we only need a small amount of input data and do not want to go through the hassle of creating, populating and then deleting tables. A nice quick solution is generating dynamic data through a Common Table Expression (CTE). Take a look at the following code. WITH CTE … More TSQL Tips – VALUES in FROM Clause

TSQL Tips – VALUES in FROM Clause

Archives

  • October 2021 (2)
  • June 2020 (1)
  • May 2020 (1)
  • November 2019 (2)
  • October 2019 (1)
  • September 2019 (3)
  • December 2018 (1)
  • November 2018 (2)
  • September 2018 (1)
  • August 2018 (5)
  • July 2018 (18)
  • June 2018 (6)
  • May 2018 (5)
  • April 2018 (14)
  • March 2018 (14)
  • February 2018 (6)
  • January 2018 (9)

Tags

ACID Azure BASE C# CAP CD Cheatsheet CI Command Prompt Containers CPlusPlus Design DevOps Docker EF6 ES6 Excel Font Git GitHub GraphDB Hidden Gems Interop Javascript JSON Key Value Store Linux LocalDB Log4Net MSTest Neo4J NoSQL NUnit OData PGAgent PostgreSQL Postman Powershell Putty Python Redis Reflection Regex REST API SOLID SQL Server SQL Server 2017 SQL Server Data Tools SSDT SSH TDD TSQL Unit Testing Visual Studio VS2019 VSTS WebApi x64 x86 XUnit

Feed

  • RSS - Posts
  • RSS - Comments
Blog at WordPress.com.
  • Follow Following
    • Denham Coder
    • Already have a WordPress.com account? Log in now.
    • Denham Coder
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar