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