我可以使用output into将数据添加到具有附加值的关系表中吗?

好吧,根据你的描述,这是可行的:

SET NOCOUNT ON;

DECLARE @Articles TABLE (id INT NOT NULL
  , [key] VARCHAR(50) NOT NULL
  , [date] DATE NOT NULL);

DECLARE @ArticleTranslations TABLE (id INT NOT NULL
  , article_key VARCHAR(50) NOT NULL
  , lang VARCHAR(50) NOT NULL
  , title VARCHAR(50) NOT NULL
  , content VARCHAR(50) NOT NULL);

INSERT @Articles (id, [key], [date]) -- This is insert into @Articles
OUTPUT INSERTED.id, INSERTED.[key], 'en', 'lorem', 'ipsum' -- This is insert into @ArticleTranslations
INTO @ArticleTranslations (id, article_key, lang, title, content) -- This is insert into @ArticleTranslations
VALUES (1, 'somekey', GETDATE()); -- This is insert into @Articles

SELECT *
FROM @Articles;

SELECT *
FROM @ArticleTranslations;

尝试此堆栈交换: https://data.stackexchange.com/stackoverflow/query/857925

也许不是那么简单。所以让我知道这是否有效。