«
»

SQLSERVER查询表行数和列数

①返回表行(记录)数

1
SELECT COUNT(*) AS 行数 FROM 表名

②返回表列(字段数)

1
SELECT COUNT(*) AS 列数 FROM syscolumns WHERE (id = OBJECT_ID( '表名'))

BeiTown
2013.08.01

本文链接：SQLSERVER查询表行数和列数

转载声明：BeiTown原创，转载请注明来源：BeiTown's Coder 编码之源，谢谢


Tags: , , ,

This entry was posted on 星期四, 八月 1st, 2013 at 21:47 and is filed under 数据库. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed. 21 views

发表评论

电子邮件地址不会被公开。 必填项已用 * 标注

*

您可以使用这些 HTML 标签和属性： <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>