T-Sql

T-Sql

Page update date :
Page creation date :

Tips related to T-SQL.

Specify the number of records to be retrieved as a percentage

Specify the number of records to be retrieved as a percentage

Describes how to specify what percentage of records are retrieved in the top of all records when retrieving records from SQL Server.
INSERT a column with IDENTITY set

INSERT a column with IDENTITY set

Describes how to enable columns that have IDENTITY set to have values that cannot be set by a regular INSERT.
Get a list of table and column names created in the database

Get a list of table and column names created in the database

Describes how to use SQL to retrieve a list of table and column names that have been created in a database.
Aggregating products

Aggregating products

Describes how to aggregate products by multiplication.
Performing aggregation processing inside recursive processing using common table expressions

Performing aggregation processing inside recursive processing using common table expressions

Describes how to perform aggregation processing in recursive common table expressions that cannot normally be executed.
Performing cumulative calculations in SQL

Performing cumulative calculations in SQL

The cumulative value of the amount in year-month units is calculated using SQL.
Extract only the first one from the record unit where the value of the specified column is duplicated

Extract only the first one from the record unit where the value of the specified column is duplicated

This section describes how to sort duplicate records by arbitrary conditions and retrieve the first record from each duplicate record.
SQL to determine whether a single piece of data is executed by key in an Update or Insert

SQL to determine whether a single piece of data is executed by key in an Update or Insert

Update if the key exists, otherwise execute the Insert in SQL.
Changing the Recovery Model of a Database in SQL

Changing the Recovery Model of a Database in SQL

Use SQL to change the recovery model of a database.