SCROLL BAR CURSOR

DECLARE CsrKaryawan SCROLL CURSOR

  FOR select NIK, NAMA from Karyawan

  --2.Buka cursor

  Open CsrKaryawan

  --3.Proses cursor

  DECLARE @nik CHAR(10), @nama VARCHAR(30)

  FETCH NEXT FROM csrKaryawan  into @nik, @nama

  PRINT @NIK + @NAMA

 

  FETCH NEXT FROM csrKaryawan  into @nik, @nama

  PRINT @NIK + @NAMA

  FETCH NEXT FROM csrKaryawan  into @nik, @nama

  PRINT @NIK + @NAMA

    --4.Tutup Cursor

  Close CsrKaryawan

  --5.Dealokasi Cursor

  Deallocate CsrKaryawan