sql - INSERT INTO 语句中的大小写

Question

我试图在未提供 ActionReq 时将此存储过程的 ActionReq 列设置为 Expiration + AdvancedCancel 的值。 ActionReq 和 Expiration 是日期时间，AdvancedCancel 是一个整数。我该怎么做？我的 SQL 技能非常基础。

ALTER PROCEDURE [dbo].[insertIntoGrid] 
    @Vendor nvarchar(max),
    @Product nvarchar(max),
    @Type nvarchar(max),
    @AccountCode nvarchar(max),
    @2016AccCode nvarchar(max),
    @BusinessUnit nvarchar(max),
    @Group nvarchar(max),
    @TIAYTD nvarchar(max),
    @ContractPeriod nvarchar(max),
    @RenewPeriod nvarchar(max),
    @Expiration datetime,
    @AdvancedCancel nvarchar(max),
    @ActionReq datetime,
    @Notes nvarchar(max),
    @Division nvarchar(max)
AS
BEGIN
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    INSERT INTO TestRedo3(Vendor, [Product/Service], [Type], AccountCode,
                          [2016AccCode], BusinessUnit, [Group], TIAYTD,
                          ContractPeriod, RenewPeriod, Expiration, AdvancedCancel,
                          case [ActionReq] is null THEN dateadd(day, @AdvancedCancel, @Expiration) 
                            else ActionReq
                          end as ActionReq, Notes, Division) 
    VALUES (@Vendor, @Product, @Type, @AccountCode,
            @2016AccCode, @BusinessUnit, @Group, @TIAYTD,
            @ContractPeriod, @RenewPeriod, @Expiration, @AdvancedCancel,
            @ActionReq, @Notes, @Division)
END

Answer 1

您需要将插入内容更改为类似这样的内容。我不完全确定您要做什么，但这应该很接近。

INSERT INTO TestRedo3
(
    Vendor,
    [Product/Service],
    [Type],
    AccountCode,
    [2016AccCode],
    BusinessUnit,
    [Group],
    TIAYTD,
    ContractPeriod,
    RenewPeriod,
    Expiration,
    AdvancedCancel,
    ActionReq,
    Notes,
    Division
) 
select 
    @Vendor,
    @Product,
    @Type,
    @AccountCode,
    @2016AccCode,
    @BusinessUnit,
    @Group,
    @TIAYTD,
    @ContractPeriod,
    @RenewPeriod,
    @Expiration,
    @AdvancedCancel,
    case when @ActionReq is null THEN dateadd(day, @AdvancedCancel, @Expiration) 
        else @ActionReq
    end,
    @Notes,
    @Division