获取SQL Server数据库里表占用容量大小
[ 2010-07-02 22:56:29 | 作者: admin ]
1、建立存储过程
CREATE PROCEDURE get_tableinfo AS
if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tablespaceinfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
create table tablespaceinfo --创建结果存储表
(nameinfo varchar(50) ,
rowsinfo int , reserved varchar(20) ,
datainfo varchar(20) ,
...if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tablespaceinfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
create table tablespaceinfo --创建结果存储表
(nameinfo varchar(50) ,
rowsinfo int , reserved varchar(20) ,
datainfo varchar(20) ,
阅读全文…
这些天gmail出现登陆后无法跳转的问题
[ 2010-07-02 22:25:13 | 作者: admin ]
p.s. 用域名 https://mail.google.com/ 可以正常访问
1
