mamekun
4/9/2013 - 9:24 AM
cursor.sql
declare csrUpdateCarton cursor FOR -- declare
SELECT * FROM <table>
open csrUpdateCarton -- open
fetch next FROM csrUpdateCarton -- fetch
INTO
@var,
@var,
@var...
while @@fetch_status = 0 -- loop
begin
/* main process */
fetch next FROM csrUpdateCarton -- fetch
INTO
@var,@var,@var...
end
close csrUpdateCarton -- close
deallocate csrUpdateCarton -- deallocate