Google Cloud Summit came to London last week, and we took the opportunity to sit down with database execs Sailesh ...

The “Conversion failed when converting date and/or time from character string” error in SQL Server appears when SQL Server cannot interpret a text value as a ...

A (somewhat opinionated) list of SQL tips and tricks that I've picked up over the years. There's so much you can do with SQL but I've focused on what I find most useful in my day-to-day work as a data ...

Abstract: The lack of information within relational databases expressed as NULL values presents a problem in ensuring the quality of data and the information retrieved by SQL queries. This is so ...

GBase南大通用大规模分布式并行数据库集群系统GBase 8a MPP Cluster中NULL和空值区别与大多数据库无甚差异，其主要特征点包括有： 1.空值（null）是不能参与任何计算，因为空值参与任何计算都为空;在进行count()统计某列的记录数的时候，如果采用的NULL值，系统会 ...

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 ...

从业以来前面的几年主要在做客户端开发，用到的数据库都是表结构比较简单的 SQLite，以我那还给老师一大半的 SQL 水平倒也能对付。现在转岗做后端开发，就显得有点捉襟见肘了，特别是各种 JOIN，有时候傻傻分不清楚，于是索性弄明白并做个记录。 前言 在 ...