sql 检查表是否有某个字段，然后根据检查结果继续执行查询

[Jenf_Mu]

declare @StatusExist bit
IF COL_LENGTH('Appointment', 'Status') IS NOT NULL
    select @StatusExist = 1  
ELSE  
    select @StatusExist = 0

select ID,
case when  @StatusExist = 0 then NULL
else Status end
as Status
 from Appointment

虽然上面可以检查出有没有Status列，但是下面执行的时候在没有Status列的情况下，还是会检查这列，导致SQL错误。

[卖水果的net]

或者使用动态语句 declare @sql varchar(1000) if ... set @sql = "select id, name from t " else set @sql = "select status from t "

[中国风]

只能用动态SQL,参照 e.g.

declare @StatusExist BIT,@Sql VARCHAR(max)
IF COL_LENGTH('Appointment', 'Status') IS NOT NULL
    select @StatusExist = 1  
ELSE  
    select @StatusExist = 0
SET @Sql='
select ID'+
case when  @StatusExist = 1 then ',Status' ELSE '' END 
+ ' from Appointment' 

PRINT @Sql

[繁花尽流年]

declare @StatusExist bit IF COL_LENGTH('Appointment', 'Status') IS NOT NULL select ID,Status from Appointment ELSE select ID, NULL as Status from Appointment