Ben Chuanlong Du's Blog

It is never too late to learn.

Volatile CTE and Subqueries in SQL

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

  1. A volatile table persistents in the duration of the connection that creates it while a CTE is only accessible by the query following it. That is the scope of CTE is …

Connect to Databases Using pyodbc in Python

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

pyodbc only supports qmark

https://github.com/mkleehammer/pyodbc/wiki

Unicode Converter Buffer Overflow

This issues arises in Python3 but not Python2, so the simplest way is to use Python2 if …

Tips on MS SQL Server

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

  1. convert: 106 - dd mon yyyy, 101 - mm/dd/yyyy