从sql表中选择字段名

Question

我有一个表Master在我的数据库字段

    Column Name       Data Type 
    ===========     =============
    Empno          varchar(10)
    Surname        varchar(10)
    ShiftDiffInd   varchar (1)
    PrevEmpGrossy  money
    NonTaxYtodate  money

我想从这个表中获取字段名，只有这两个字段'ShiftDiffInd' 'NonTaxYtodate'。这个字段没有值，所以我怎么做

我想要这样的回报

==============
ShiftDiffInd
NonTaxYtodate

Answer 1

select
   syscolumns.name as [Column]
from 
   sysobjects, syscolumns 
where sysobjects.id = syscolumns.id
and   sysobjects.name = 'Master'
and (syscolumns.name = 'ShiftDiffInd' or syscolumns.name = 'NonTaxYtodate')
order by syscolumns.name

Answer 2

 select column_name from INFORMATION_SCHEMA.COLUMNS
where 1=1
    and TABLE_NAME = 'Master'
    and COLUMN_NAME in ('ShiftDiffInd','NonTaxYtodate')

Answer 3

SELECT 'ShiftDiffInd' as ShiftDiffInd, 'NonTaxYtodate' as NonTaxYtodate , * FROM Master

Answer 4

我以前误解了你的问题，尝试下面的查询，你得到预期的结果:

 SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME=OBJECT_NAME(OBJECT_ID('Master'))
AND COLUMN_NAME IN ('ShiftDiffInd','NonTaxYtodate')