随笔分类 -  MSSQL

SQLServer
摘要:统计当前库中所有表的记录数量:在 MSSQL2008 R2中运行if exists (select Name from sysobjects where name='count_table_recorder' and type='p') drop proc count_table_recordercreate proc count_table_recorder @DbName varchar(255), @TableType nvarchar(10), @OneResult nvarchar(4000) outputAS declare table_cursor 阅读全文
posted @ 2012-05-16 17:16 fg0711 阅读(297) 评论(0) 推荐(0)