CodeZine（コードジン）

WITH RESULT SET構文について

2003年11月にリリースされたSQL Anywhere 9.0.1のEBF（ビルド1699）で初めて導入された、WITH RESULT SET構文を紹介します。この構文はストアドプロシージャが出力パラメータを持つ場合に生じる、ある特定の問題を回避するために開発されました。 （原文：Using WITH ...
InfoQ

Google Proposes Adding Pipe Syntax to SQL

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...
GitHub

Ecto 3.13.0 generates DO UPDATE SET with no fields, leading to SQL syntax error

\*\* (Postgrex.Error) ERROR 42601 (syntax\_error) syntax error at or near "RETURNING" query: INSERT INTO "field_names" ("name") VALUES ($1) ON CONFLICT ("name") DO ...
Ars Technica

SQL Server 2005 TSQL syntax for getting dta out of an update or insert

this will return: "(1 row(s) affected)" But now I need to know, what data was actually inserted? SQL Server has answered this question in 2005 with the OUTPUT statement: This will return a dataset ...