Execute@ with another @

Question

我怎么才能让它工作呢？我希望能够根据变量是0还是1来更新@result 0，然后将其放入另一个集合@，然后调用@result。##tempz表确实存在。但是，当我运行此命令时，它只给出：(125行受影响)

DECLARE @result nvarchar(max),@result0 nvarchar(max)
SET @showstore = 1
SET @showcashier = 0
SET @showregister = 0
SET @showdate = 0  

set @result = 'select '+@result0+' from ##tempz'
set @result0 = 'Amex,[Gift Card],Debit,[Off Line C.Card],[Str Cr],[House Acct],Cash,Rebate,[C.Card],VIP,Discover,[Check],MasterCard,[Visa/MC]'

If @showstore = 1
    begin
        set @result0 = 'StoreID,' + @result0
    end
If @showcashier = 1
    begin
        set @result0 = 'Cashier,' + @result0
    end
If @showregister = 1
    begin
        set @result0 = 'Register,' + @result0
    end
If @showdate = 1
    begin
        set @result0 = 'Date,' + @result0
    end
execute(@result)

Answer 1

在所有IF..ELSE之后，您应该在最后一行设置@result的值

DECLARE @result nvarchar(max),@result0 nvarchar(max)
SET @showstore = 1
SET @showcashier = 0
SET @showregister = 0
SET @showdate = 0  

set @result0 = 'Amex,[Gift Card],Debit,[Off Line C.Card],[Str Cr],[House Acct],Cash,Rebate,[C.Card],VIP,Discover,[Check],MasterCard,[Visa/MC]'

If @showstore = 1
    begin
        set @result0 = 'StoreID,' + @result0
    end
If @showcashier = 1
    begin
        set @result0 = 'Cashier,' + @result0
    end
If @showregister = 1
    begin
        set @result0 = 'Register,' + @result0
    end
If @showdate = 1
    begin
        set @result0 = 'Date,' + @result0
    end
set @result = 'select '+@result0+' from ##tempz'
execute(@result)