22,300
社区成员




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
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