如何插入到为每列指定 DEFAULT 值的表中? [英] How to insert into a table that specifies a DEFAULT value for every column?

问题描述

我有一个表格，每当发生插入时，所有列都会自动填充:

I have a table where all columns are auto-populated whenever an insertion happens:

CREATE TABLE …
(
    ItemID      INT       NOT NULL IDENTITY(…),
    DateCreated DATETIME2 NOT NULL DEFAULT GETDATE()
);

如何编写 SQL 语句将新行插入到该表中，而无需手动提供要插入的任何具体值?

How do I write a SQL statement that inserts a new row into this table without having to manually provide any concrete values to insert?

(已经有一个类似的问题，但是它的不同之处在于它是关于具有一些非DEFAULT 列的表，必须手动为其提供值.)

(There is already a similar question, but it differs in that it's about a table with some non-DEFAULT columns for which a value must be manually provided.)

推荐答案

使用 DEFAULT VALUES 选项:

INSERT INTO IndentitySpecification
DEFAULT VALUES;

这篇关于如何插入到为每列指定 DEFAULT 值的表中?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！