我想CONCAT在我SELECT在 SQL Server 中的陳述句之間進行此操作。
所有列都是布林值。
如果所有列都為真，則輸出將是這樣的
GGPNES
我嘗試使用它但它不起作用
DECLARE @concat VARCHAR(40) ='';
SELECT
Smoke, Invoice,
Party, Summary,
MySelf, Export,
CASE
WHEN MyTable.Smoke = 1 OR MyTable.Invoice = 1
THEN @concat 'GG'
WHEN MyTable.Party = 1
THEN @concat 'P'
WHEN MyTable.Summary = 1
THEN @concat 'N'
WHEN MyTable.MySelf = 1
THEN @concat 'E'
WHEN MyTable.Export = 1
THEN @concat 'S'
END
FROM
MyTable
uj5u.com熱心網友回復：
我認為你想要一個CASE運算式的串聯：
CASE WHEN Smoke = 1 OR Invoice = 1 THEN 'GG' ELSE '' END
CASE WHEN Party = 1 THEN 'P' ELSE '' END
CASE WHEN Summary = 1 THEN 'N' ELSE '' END
CASE WHEN MySelf = 1 THEN 'E' ELSE '' END
CASE WHEN Export = 1 THEN 'S' ELSE '' END
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/494085.html