INSERT INTO在CASE语句中 [英] INSERT INTO in a CASE statement

问题描述

我想知道是否可以在SQL代码中的CASE语句中有一个INSERT INTO语句。

I'm wondering if it's possible to have a INSERT INTO statement within a CASE statement in SQL code.

这是一个粗略的伪代码，我正在尝试做：

Here's a rough pseudocode of what I'm trying to do:

SELECT (CASE (SELECT SomeValue FROM SomeTable)
            WHEN NULL THEN
                INSERT INTO OtherTable VALUES (1, 2, 3)
                (SELECT NewlyInsertedValue FROM OtherTable)
            ELSE
                (SELECT SomeOtherValue FROM WeirdTable)
        END),
       Column1,
       Column2
FROM BigTable

推荐答案

您将需要完成与 IF ... THEN 语句来代替。大概这样的东西（不确定db2的语法）：

You will need to accomplish with IF...THEN statements instead. Something roughly like this (not sure about syntax for db2):

SELECT @SomeValue = SomeValue FROM SomeTable

IF @SomeValue IS NULL
    INSERT INTO OtherTable VALUES (1, 2, 3)
    SELECT NewlyInsertedValue FROM OtherTable;
ELSE
    INSERT INTO OtherTable VALUES (1, 2, 3)
    SELECT SomeOtherValue FROM WeirdTable;
END IF;

这篇关于INSERT INTO在CASE语句中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！