27,579
社区成员
发帖
与我相关
我的任务
分享
select case when Employee = @employee then item else 'N/A' END AS EMPLOYEE
FROM TBNAME
if exists(select 1 from test where Employee = 222)
select * from tb
else
select 'N/A'
SELECT ITEM FROM TEST WHERE Employee =@Employee
UNION ALL
SELECT 'N/A' FROM TEST WHERE NOT EXISTS(SELECT 1 FROM TEST WHERE Employee =@Employee)
DECLARE @a VARCHAR(10)
DECLARE @aaa VARCHAR(4)
IF EXISTS(SELECT 1 FROM TB WHERE employee = @a)
SELECT @aaa = ISNULL(item,'N/A') FROM TB WHERE employee = @a
ELSE
SET @aaa = 'N/A'
case when