摘要: select b.[value] from sys.columns a left join sys.extended_properties b on a.object_id=b.major_idand a.column_id=b.minor_id inner join sysobjects c on a.column_id=c.idand a.[name]='列名' and c.[name]='表名'SELECT表名=case when a.colorder=1 then d.name else '' end,表说明=case when a.co 阅读全文
posted @ 2011-11-30 13:39 野三坡 阅读(142) 评论(0) 推荐(0) 编辑