sql-server - 如何在变量 SQL Server 中制作查询​​语句大小写

Question

这有效：

select 
    idpelamar,
    case 
       when jk = 'L' then 'Laki' 
       when jk = 'P' then 'Perem' 
    end as XJENIS
from tblpelamar

如何应用case语句来初始化变量？

像下面这样：

declare @jenis nvarchar(1)
declare @perintah nvarchar(100)
set @jenis = 'L'

set @perintah = 'case when jk=@jenis then Laki when jk=@jenis then Prem end as XJENIS'

select 
    idpelamar,
    +@perintah
from tblpelamar

标签： sql-servercase

Answer 1

这回答了你的问题了吗？

declare @jenis1 as nvarchar(1) = 'L';
declare @jenis2 as nvarchar(1) = 'P';

select idpelamar,
       case jk
         when @jenis1 then 'Laki'
         when @jenis2 then 'Prem'
       end as XJENIS
from tblpelamar;

小提琴