note

Transact-SQLでテーブルのプライマリキーを調べる

Transact-SQLでテーブルのプライマリキーを調べるには、次のクエリを使用します。 SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE OBJECTPROPERTY(OBJECT_ID(CONSTRAINT_SCHEMA + '.' + CONSTRAINT_NAME), 'IsPrimaryKey') = 1 ...
マイナビニュース

Transact-SQLの関数を理解しよう - 文字列編

続けて、文字列の繰り返し、変換、空白除去関連の関数について見ていきましょう。 繰り返し、変換、空白除去関連の関数一覧 関数名 戻り値 説明 SPACE char 指定した個数の半角スペースを返します REPLICATE 文字列(入力値依存) 文字列を指定した回数分 ...
GitHub

delete-transact-sql.md

Specifies the temporary named result set, also known as common table expression, defined within the scope of the DELETE statement. The result set is derived from a SELECT statement. Common table ...
GitHub

restore-statements-for-restoring-recovering-and-managing-backups-transact-sql.md

In previous versions of SQL Server, any user could obtain information about backup sets and backup devices by using the RESTORE FILELISTONLY, RESTORE HEADERONLY, RESTORE LABELONLY, and RESTORE ...
archive

The guru's guide to Transact-SQL

Ask the publishers to restore access to 500,000+ books. Can You Chip In? We’re celebrating our 1 trillionth archived web page. If you find our library useful, learn how you can help us fundraise! Can ...
Visual Studio Magazine

Data Virtualization in SQL Server 2022

PolyBase, a data virtualization feature for SQL Server, allows users to seamlessly query data from various external sources directly using T-SQL (Transact-SQL) without the need for separate client ...