如何使用 Select 语句隐藏列？

您只需要在列表中添加一条case语句select：

declare @bid varchar(4) = '1007'    

select sr.release_date,
    sr.customer_id,
    sr.customer_name,
    sr.item_id,
    sr.item_desc,
    sr.order_no,
    sr.qty_on_hand,
    sr.release_qty,
    sr.qty_after_released,
    sr.extended_sell,
    sr.enough,
    case when sr.route_code in ('pm 01','pm 03','pm 05') then sr.route_description else '' end as route_description
from sri_schedule_releases_view as sr
where 
    ((case 
        when sr.route_code in ('pm 01','pm 03','pm 05') then (select users.contact_id from users where users.delete_flag = 'n' and users.name = 'John')
    end = @bid) or 
    (case 
        when sr.route_code in ('pm 01','pm 03','pm 05') then (select users.contact_id from users where users.delete_flag = 'n' and users.name = 'Jane')
    end = @bid) or
    (case 
        when sr.route_code in ('pm 01','pm 03','pm 05') then (select users.contact_id from users where users.delete_flag = 'n' and users.name = 'Doe')
    end = @bid) or
    (sr.contact_id = @bid))
order by sr.item_id asc

我找到了一个解决方案，它按我的预期工作

declare @bid varchar(4) = '1007'    

declare @pm1 varchar(5) = (select users.contact_id from users where users.delete_flag = 'n' and users.name = 'John')
declare @pm3 varchar(5) = (select users.contact_id from users where users.delete_flag = 'n' and users.name = 'Jane')
declare @pm5 varchar(5) = (select users.contact_id from users where users.delete_flag = 'n' and users.name = 'Doe')

if @bid in (@pm1,@pm3,@pm5) 
begin
select sr.release_date,
    sr.customer_id,
    sr.customer_name,
    sr.item_id,
    sr.item_desc,
    sr.order_no,
    sr.qty_on_hand,
    sr.release_qty,
    sr.qty_after_released as available_qty,
    sr.extended_sell as ext_sell,
    sr.enough,
    sr.route_description

from sri_schedule_releases_view as sr

where 
   ((case 
      when sr.route_code in ('pm 01','pm 03','pm 05') then @pm1
   end = @bid) or 
   (case 
      when sr.route_code in ('pm 01','pm 03','pm 05') then @pm3
   end =@bid) or
   (case 
      when sr.route_code in ('pm 01','pm 03','pm 05') then @pm5
   end = @bid) or
   (sr.contact_id = @bid))
end
else
begin
select sr.release_date,
    sr.customer_id,
    sr.customer_name,
    sr.item_id,
    sr.item_desc,
    sr.order_no,
    sr.qty_on_hand,
    sr.release_qty,
    sr.qty_after_released as available_qty,
    sr.extended_sell as ext_sell,
    sr.enough

from sri_schedule_releases_view as sr

where 
   ((case 
      when sr.route_code in ('pm 01','pm 03','pm 05') then @pm1
   end = @bid) or 
   (case 
      when sr.route_code in ('pm 01','pm 03','pm 05') then @pm3
   end =@bid) or
   (case 
      when sr.route_code in ('pm 01','pm 03','pm 05') then @pm5
   end = @bid) or
   (sr.contact_id = @bid))
end

如果您只想在数据存在时显示该列，那么可以在 IF 语句中创建一个具有两种可能性的函数：

IF 数据存在（运行正常查询） ELSE
（复制相同的查询但没有空列）

代码太多——只需创建一个包含整个结果集的临时表。

SELECT * INTO #tmpTbl FROM MyDatabase.dbo.tbl 

ALTER TABLE 

REMOVE columname

SELECT * FROM #tmpTbl 

DROP TABLE #tmpTbl