transaction contoh untuk ke simanis

BEGIN TRANSACTION [Tran1]

  BEGIN TRY


            /****** Object:  Index [ix_tgl_bayar]    Script Date: 3/24/2020 11:06:52 AM ******/
            DROP INDEX if exists [ix_tgl_bayar] ON [dbo].[datpenagihan]


            /****** Object:  Index [ix_tgl_bayar]    Script Date: 3/24/2020 11:06:52 AM ******/
            CREATE NONCLUSTERED INDEX [ix_tgl_bayar] ON [dbo].[datpenagihan]
            (
                [tglbayar] ASC,
                [status_bayar] ASC,
                [kdkc] ASC
            )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)


      COMMIT TRANSACTION [Tran1]

  END TRY

  BEGIN CATCH

      ROLLBACK TRANSACTION [Tran1]

  END CATCH