插入没有值的表的语法?

2022-01-09 00:00:00 sql insert tsql sql-server

我有一个使用以下架构创建的表:

I have a table created with the following schema:

CREATE TABLE [dbo].[Visualizations]
(
    VisualizationID     int identity (1,1)      NOT NULL
)

由于表格没有可设置的字段，我不确定如何插入记录.我试过了:

Since the table has no settable fields, I'm not sure how to insert a record. I tried:

INSERT INTO [Visualizations];
INSERT INTO [Visualizations] () VALUES ();

都不行.这样做的正确语法是什么?

Neither work. What is the proper syntax to do this?

由于许多人似乎对我的表感到困惑，因此它纯粹用于表示许多子表的父表...每个子表都通过 FK 引用该表，并且每个这些 FK 中的一部分是 PK，因此在所有这些表中，ID 都是唯一的.

Since a number of people seem confused by my table, it is used purely to represent a parent of a number of sub-tables... each one references this table by FK and each of those FKs are PKs, so that across all of those tables, the IDs are unique.

推荐答案

参见 this(例如F. Load data using the DEFAULT VALUES option"):

See this (example "F. Load data using the DEFAULT VALUES option"):

INSERT INTO [Visualizations] DEFAULT VALUES;

相关文章