YouTube on MSN

How PostgreSQL functions turn messy data into useful results

This PostgreSQL tutorial demonstrates practical ways to clean, transform, and analyze database information using built-in ...
learn

Microsoft ODBC Driver for SQL Server

ODBC is a native data access application programming interface (API) for applications written in C and C++. The Microsoft ODBC Driver for SQL Server connects to SQL Server, Azure SQL Database, Azure ...
note

About substr, instr, and trim

These three functions are extremely powerful and can be called the "three sacred treasures" of text (string) data cleansing in SQLite. Once you master how they work, you will be able to perform any ...
note

substr instr trim について

この3つの関数は、SQLiteにおけるテキスト（文字列）データクレンジングの「三種の神器」とも言える非常に強力な関数です。仕組みをマスターすると、どんな複雑な文字列整形も自由自在に ...
learn

RIGHT (Transact-SQL)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric SQL database in Microsoft Fabric ...
blog.csdn

Metabase substring 表达式详解：从文本中精准截取子串的完整指南

【免费下载链接】metabase The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart: 项目 ...
devblogs

SQL Decomposition in a Nutshell

Application developers already know what happens when one method does everything: it becomes difficult to read, test, reason over, and safely change. We use patterns like decomposition, encapsulation, ...
builtin

Understanding SQL Query Order of Execution

After writing a considerable number of SQL scripts, you’re likely to reach a performance plateau. You extract insights using the same strategies and run into the same types of errors. Fortunately, you ...
habr

Ошибки, которые не случились: C++ и compile‑time проверка SQL-запросов

Ключевые слова constexpr/consteval в С++ живут уже не первый год, но для многих по‑прежнему остаются чем‑то неясными или чересчур академичными.
GitHub

From SQL to SPL：Substring from a column of strings

105009400068600 WNr1.4112 Inox Rund 8.00 mm nach EN 10088-3 + A+C+SL, gesch 105009400068700 WNr1.4301 Inox Rund 36.00 mm nach EN 10088-3, geschliffen, T 105009400068800 WNr1.4104 Inox Rund 25.00 mm ...
bilibili

鲸析SQL刷题挑战 DAY 5：substring细节

SUBSTRING(str, start [, length]) str：表示要进行提取操作的原始字符串。 start：指定开始提取的位置。位置从 1 开始计数，如果 start 为正数，则从字符串的开头开始计数；如果 start 为负数，则从 ...
builtin

SQL Functions With Examples

SQL functions are prewritten actions that can be called on individual cells, multiple cells in a record or multiple records. Using the “Weather” table, we could use the AVG function to calculate the ...