|
3>
4> DECLARE @AWTables TABLE (SchemaTable varchar(100))
5> DECLARE @TableName varchar(100)
6>
7> WHILE (SELECT COUNT(*) FROM @AWTables)>0
8> BEGIN
9> SELECT TOP 1 @TableName = SchemaTable FROM @AWTables ORDER BY SchemaTable
10> EXEC sp_spaceused @TableName
11> DELETE @AWTables WHERE SchemaTable = @TableName
12> END
13>
14> WHILE (1=1)
15> BEGIN
16> PRINT '1 --- 1'
17> IF 1=1
18> BEGIN
19> PRINT 'Break up now.'
20> BREAK
21> END
22> ELSE
23> BEGIN
24> CONTINUE
25> END
26> END
27> GO
1 --- 1
Break up now.
|