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