请任何人给我指一下正确的方向。我要检查列是否存在，如果存在，请选择此列，否则请选择其他列

select case 
   when exists (
      SELECT *
      FROM Sys.columns c 
      WHERE c.[object_id] = OBJECT_ID('dbo.Municipality') 
         AND c.name = 'AmountTypeLabel'
   )  
   then 1
   else 0
 end

检查列是否存在，然后返回0或1，但没有列名，因此无法在c中检查#
这是我在c中尝试过的#但是正如我之前所说的，没有列名称

DataTable DT;
        string SQL = "";
        try
        {

            SQL = "select case " +
                  " when exists( " +
                  "  SELECT 1 " +
                  "  FROM Sys.columns c " +
                  " WHERE c.[object_id] = OBJECT_ID('dbo.Municipality')" +
                  "  AND c.name = 'AmountTypeLabel'" +
                  ")" +
                  " then 1 " +
                  " else 0 " +
                  " end ";
            DT = Conn.ExecuteDT(SQL);
        }
        catch (Exception ex)
        {
            throw new Exception("Unable to get Tables", ex);
        }
        return DT;
    }