
24/03/2013 0 Sybase - Cursor example | |
Mots-clés: Sybase SQL | |
CREATE PROCEDURE ps_purge @for varchar(10), @typeRun varchar(10), @int nbDays DECLARE cursorPurge CURSOR FOR SELECT RunIndex FROM tbRun WHERE For = @for AND TypeRun = @typeRun AND DateRun < dateadd(dd, -nbDays, getDate()) DECLARE @runIndex numeric(18,0) OPEN cursorPurge WHILE @@sqlstatus = 0 BEGIN FETCH cursorPurge INTO @runIndex exec ps_purge_run @runIndex END CLOSE cursorPurge DEALLOCATE CURSOR cursorPurge | |