摘要: select * from yourdb.dbo.sysobjects where name='tablename' 阅读全文
posted @ 2014-07-24 16:37 Creatisan 阅读(210) 评论(0) 推荐(0) 编辑
摘要: 1.首先,我们来介绍第一种方式:◆查询的SQL语句如下:select row_number() over (order by name) as rowid, sysobjects.[name] from sysobjects◆运行的结果:rowid name1 all_columns2 all_ob... 阅读全文
posted @ 2014-07-24 15:20 Creatisan 阅读(30367) 评论(0) 推荐(0) 编辑