萬盛學電腦網 >> 數據庫 >> sql server教程 >> aboutspaceused
aboutspaceused
declare @TableName varchar(200)
create table #tmpTable(name nvarchar(20),rows char(11),reserved varchar(18),data varchar(18),index_size varchar(18),unused varchar(18))
DECLARE myCursor CURSOR FOR select name from sysobjects where type='u'
OPEN myCursor
FETCH NEXT FROM myCursor into @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
insert into #tmptable exec sp_spaceused @TableName
FETCH NEXT FROM myCursor into @TableName
END
CLOSE myCursor
DEALLOCATE myCursor
select * from #tmpTable
drop table #tmpTable
GO
關鍵詞：
sql server教程排行
程序編程推薦
相關文章
copyright © 萬盛學電腦網 all rights reserved