sql - TSQL:选择插入中的if语句

Question

我在一个函数中有这个结构:

INSERT INTO @TheTable
    SELECT DISTINCT

        @Number AS Number,

        @Name AS Name

    FROM MYTABLE 
    WHERE id = @id

我需要将执行另一个函数的结果添加到这个结构中，我需要你的帮助。

在@Name AS Name 下方，我应该添加这样的行

IF (dbo.anotherFunction(@id)==1) 
@NewVisitor AS NewVisitor
ELSE
@NewVisitor AS NoNewVisitor

我怎样才能把它翻译成 TSQL？？

太感谢了!

Answer 1

猜猜这是你想要的......

INSERT INTO @TheTable
    SELECT DISTINCT
        @Number AS Number,
        @Name AS Name,
        case when (dbo.anotherFunction(@id)=1) then @NewVisitor else null end as NewVisitor,
        case when (dbo.anotherFunction(@id)<>1) then @NewVisitor else null end AS NoNewVisitor
    FROM MYTABLE 
    WHERE id = @id