GitHub

SQL table to HTML

This stored procedure converts a table or select query to a HTML table format, with some customization options. I have taken as a base, a script Carlos Robles (dbamastery.com) provided me for a static ...
GitHub

When creating table via to_sql(..., if exists = 'replace'..) with a DATETIME or TIMESTAMP date type, an error is raised

In fact initially I just declare DATETIME or TIMESTAMP to this field in the date type dict, but then qlalchemy changes the originally declared data type to TIMESTAMP WITHOUT TIME ZONE, and gets ...
Microsoft

Working with time series data in SQL Server 2022 and Azure SQL

Part of the SQL Server 2022 blog series. Time series data is a set of values organized in the order in which they occur and arrive for processing. Unlike transactional data in SQL Server, which is not ...