http://sqle.ru/index.php?action=history&feed=atom&title=SQL_Server%2FT-SQL_Tutorial%2FSystem_Functions%2Fsp_spaceused
SQL Server/T-SQL Tutorial/System Functions/sp spaceused - История изменений
2026-05-25T23:51:23Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/System_Functions/sp_spaceused&diff=6708&oldid=prev
в 13:46, 26 мая 2010
2010-05-26T13:46:16Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:46, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/System_Functions/sp_spaceused&diff=6709&oldid=prev
Admin: 1 версия
2010-05-26T10:24:00Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== Report on each table using sp_spaceused==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
3><br />
4> DECLARE @AWTables TABLE (SchemaTable varchar(100))<br />
5> DECLARE @TableName varchar(100)<br />
6><br />
7> WHILE (SELECT COUNT(*) FROM @AWTables)>0<br />
8> BEGIN<br />
9> SELECT TOP 1 @TableName = SchemaTable FROM @AWTables ORDER BY SchemaTable<br />
10> EXEC sp_spaceused @TableName<br />
11> DELETE @AWTables WHERE SchemaTable = @TableName<br />
12> END<br />
13><br />
14> WHILE (1=1)<br />
15> BEGIN<br />
16> PRINT "1 --- 1"<br />
17> IF 1=1<br />
18> BEGIN<br />
19> PRINT "Break up now."<br />
20> BREAK<br />
21> END<br />
22> ELSE<br />
23> BEGIN<br />
24> CONTINUE<br />
25> END<br />
26> END<br />
27> GO<br />
1 --- 1<br />
Break up now.</source><br />
<br />
<br />
<br />
== sp_spaceused reviews the space used by a table in a database.==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
You can also displace the disk space reserved and used by an entire database. <br />
The syntax is <br />
sp_spaceused [tablename[,@updateusage={TRUE�FALSE}]]</source></div>
Admin