SHARE
TWEET

transaction contoh untuk ke simanis

indrasaputra1987 Mar 24th, 2020 320 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2. BEGIN TRANSACTION [Tran1]
  3.  
  4.   BEGIN TRY
  5.  
  6.      
  7.             /****** Object:  Index [ix_tgl_bayar]    Script Date: 3/24/2020 11:06:52 AM ******/
  8.             DROP INDEX if exists [ix_tgl_bayar] ON [dbo].[datpenagihan]
  9.            
  10.  
  11.             /****** Object:  Index [ix_tgl_bayar]    Script Date: 3/24/2020 11:06:52 AM ******/
  12.             CREATE NONCLUSTERED INDEX [ix_tgl_bayar] ON [dbo].[datpenagihan]
  13.             (
  14.                 [tglbayar] ASC,
  15.                 [status_bayar] ASC,
  16.                 [kdkc] ASC
  17.             )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
  18.        
  19.  
  20.       COMMIT TRANSACTION [Tran1]
  21.  
  22.   END TRY
  23.  
  24.   BEGIN CATCH
  25.  
  26.       ROLLBACK TRANSACTION [Tran1]
  27.  
  28.   END CATCH
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top