WHILE @@FETCH_STATUS = 0 : while « Transact SQL « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Transact SQL
3. while

4>
5>
6>     DROP PROCEDURE pr_updateindex
7>     GO
1>     CREATE PROCEDURE pr_updateindex
2>     AS
3>     SET NOCOUNT ON
4>     DECLARE getindex_curs CURSOR
5>          FOR
6>               SELECT name FROM sysobjects WHERE type = 'U'
7>     DECLARE @holdtable varchar(30)
8>     DECLARE @message varchar(40)
9>     DECLARE @dynamic varchar(51)
10>     OPEN getindex_curs
11>     FETCH NEXT FROM getindex_curs into @holdtable
12>     WHILE @@FETCH_STATUS = 0 BEGIN
13>            SELECT @dynamic = "UPDATE STATISTICS " + @holdtable
14>            SELECT @message = "Updating " + @holdtable
15>            EXEC (@dynamic )
16>     PRINT @message
17>          FETCH NEXT FROM getindex_curs into @holdtable
18>     END
19>     CLOSE getindex_curs
20>     GO
1>
2>     EXEC pr_updateindex
3>
4>
5>