Monday, March 19, 2012

Continue

DECLARE @int varchar(10)  
DECLARE curs_int  CURSOR FOR
SELECT '1'
union SELECT'2'
union SELECT'3'
union SELECT'4'
union SELECT'5'
order by 1
OPEN curs_int

FETCH NEXT FROM curs_int
INTO @int
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @int
FETCH NEXT FROM curs_int
      INTO @int
    if @int = '3' continue
print @int      
END
CLOSE curs_int
DEALLOCATE curs_int

returns
1
2
2
3
4
4
5
5
5

No comments:

Post a Comment