select a.name as tabname,c.name as colname,ty.name as type_name
from
sys.tables as a
inner join sys.columns as c
on a.object_id=c.object_id
inner join sys.types as ty
on c.system_type_id=ty.system_type_id
where tabname='CR_C_AspReimburse'
消息 207，级别 16，状态 1，第 8 行
列名 'tabname' 无效。
????????
------解决方案--------------------
tabname是别名，别名不能用于where语句中 直接写 a.name = 'CR_C_AspReimburse'