PRINT COL_NAME(OBJECT_ID('tb'),1) SELECT * FROM tb WHERE COL_NAME(OBJECT_ID('tb'),1) = 'groups' 結果: groups groups item color quantity ------ ---------- ---------- ----------- aa table blue 124 bb table red -23 bb cup green -23 aa chair blue 101 aa chair red -90
SELECT * FROM tb WHERE COL_NAME(OBJECT_ID('tb'),1) = 'groups'
結果:
groups
groups item color quantity
------ ---------- ---------- -----------
aa table blue 124
bb table red -23
bb cup green -23
aa chair blue 101
aa chair red -90
groups这个表中groups这一列等于某一个数字的那一条记录,而并不是要判断这个表里有没有这一个字段。