查询 某表的 全部列

SELECT name
FROM syscolumns
WHERE (id =
          (SELECT MAX(id) AS Expr1
         FROM sysobjects
         WHERE (xtype = 'u') AND (name = 'lis_inspection_sample')))

posted on 2009-04-08 10:11  tongdengquan  阅读(136)  评论(0编辑  收藏  举报