摘要:selectb.[value]fromsys.columnsaleftjoinsys.extended_propertiesbona.object_id=b.major_idanda.column_id=b.minor_idinnerjoinsysobjectscona.column_id=c.idanda.[name]='列名'andc.[name]='表名'SELECT表名=casewhena.colorder=1thend.nameelse''end,表说明=casewhena.colorder=1thenisnull(f.value,
阅读全文
posted @ 2012-09-24 23:15