Scribd
Upload
2 views11 pages

SQL Insert Statements for Ta Tables

The document contains SQL commands to disable triggers, insert data from existing tables into draft tables for various asset categories, and then re-enable the triggers. It includes operations for tables such as Ta_Penghapusan, Ta_KIB_A, Ta_KIBAR, Ta_KIBAHapus, TA_KIB_B, and TA_KIB_C. The data being transferred includes various asset attributes and identifiers.

Uploaded by

Bims Thea
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
2 views11 pages

SQL Insert Statements for Ta Tables

The document contains SQL commands to disable triggers, insert data from existing tables into draft tables for various asset categories, and then re-enable the triggers. It includes operations for tables such as Ta_Penghapusan, Ta_KIB_A, Ta_KIBAR, Ta_KIBAHapus, TA_KIB_B, and TA_KIB_C. The data being transferred includes various asset attributes and identifiers.

Uploaded by

Bims Thea
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

ALTER TABLE Ta_Penghapusan DISABLE TRIGGER ALL

INSERT INTO [DB_KABTASIK_2022_DRAFTDISDIK].[dbo].[Ta_Penghapusan]


([Tahun]
,[No_SK]
,[Tgl_SK]
,[Keterangan]
,[Kd_Hapus])
SELECT [Tahun]
,[No_SK]
,[Tgl_SK]
,[Keterangan]
,[Kd_Hapus]
FROM [DB_KABTASIK_2022_DISDIK].[dbo].[Ta_Penghapusan]
ALTER TABLE Ta_Penghapusan ENABLE TRIGGER ALL

ALTER TABLE Ta_KIB_A DISABLE TRIGGER ALL


INSERT INTO [DB_KABTASIK_2022_DRAFTDISDIK].[dbo].[Ta_KIB_A]
([IDPemda]
,[Kd_Prov]
,[Kd_Kab_Kota]
,[Kd_Bidang]
,[Kd_Unit]
,[Kd_Sub]
,[Kd_UPB]
,[Kd_Aset1]
,[Kd_Aset2]
,[Kd_Aset3]
,[Kd_Aset4]
,[Kd_Aset5]
,[No_Register]
,[Kd_Pemilik]
,[Tgl_Perolehan]
,[Luas_M2]
,[Alamat]
,[Hak_Tanah]
,[Sertifikat_Tanggal]
,[Sertifikat_Nomor]
,[Penggunaan]
,[Asal_usul]
,[Harga]
,[Keterangan]
,[Tahun]
,[No_SP2D]
,[No_ID]
,[Tgl_Pembukuan]
,[Kd_Kecamatan]
,[Kd_Desa]
,[Invent]
,[No_SKGuna]
,[Kd_Penyusutan]
,[Kd_Data]
,[Log_User]
,[Log_entry]
,[Kd_Masalah]
,[Ket_Masalah]
,[Kd_KA]
,[No_SIPPT]
,[Dev_Id]
,[Kd_Hapus]
,[IDData]
,[Kd_Aset8]
,[Kd_Aset80]
,[Kd_Aset81]
,[Kd_Aset82]
,[Kd_Aset83]
,[Kd_Aset84]
,[Kd_Aset85]
,[No_Reg8]
,[Tg_Update8])
SELECT [IDPemda]
,[Kd_Prov]
,[Kd_Kab_Kota]
,[Kd_Bidang]
,[Kd_Unit]
,[Kd_Sub]
,[Kd_UPB]
,[Kd_Aset1]
,[Kd_Aset2]
,[Kd_Aset3]
,[Kd_Aset4]
,[Kd_Aset5]
,[No_Register]
,[Kd_Pemilik]
,[Tgl_Perolehan]
,[Luas_M2]
,[Alamat]
,[Hak_Tanah]
,[Sertifikat_Tanggal]
,[Sertifikat_Nomor]
,[Penggunaan]
,[Asal_usul]
,[Harga]
,[Keterangan]
,[Tahun]
,[No_SP2D]
,[No_ID]
,[Tgl_Pembukuan]
,[Kd_Kecamatan]
,[Kd_Desa]
,[Invent]
,[No_SKGuna]
,[Kd_Penyusutan]
,[Kd_Data]
,[Log_User]
,[Log_entry]
,[Kd_Masalah]
,[Ket_Masalah]
,[Kd_KA]
,[No_SIPPT]
,[Dev_Id]
,[Kd_Hapus]
,[IDData]
,[Kd_Aset8]
,[Kd_Aset80]
,[Kd_Aset81]
,[Kd_Aset82]
,[Kd_Aset83]
,[Kd_Aset84]
,[Kd_Aset85]
,[No_Reg8]
,[Tg_Update8]
FROM [DB_KABTASIK_2022_DISDIK].[dbo].[Ta_KIB_A]
ALTER TABLE Ta_KIB_A ENABLE TRIGGER ALL

ALTER TABLE Ta_KIBAR DISABLE TRIGGER ALL


INSERT INTO [DB_KABTASIK_2022_DRAFTDISDIK].[dbo].[Ta_KIBAR]
([IDPemda]
,[Kd_Id]
,[Kd_Riwayat]
,[Kd_Prov]
,[Kd_Kab_Kota]
,[Kd_Bidang]
,[Kd_Unit]
,[Kd_Sub]
,[Kd_UPB]
,[Kd_Aset1]
,[Kd_Aset2]
,[Kd_Aset3]
,[Kd_Aset4]
,[Kd_Aset5]
,[No_Register]
,[Kd_Pemilik]
,[Tgl_Dokumen]
,[No_Dokumen]
,[Tgl_Perolehan]
,[Tgl_Pembukuan]
,[Luas_M2]
,[Alamat]
,[Hak_Tanah]
,[Sertifikat_Tanggal]
,[Sertifikat_Nomor]
,[Penggunaan]
,[Asal_usul]
,[Harga]
,[Keterangan]
,[Tahun]
,[No_SP2D]
,[No_ID]
,[Kd_Kecamatan]
,[Kd_Desa]
,[Kd_Prov1]
,[Kd_Kab_Kota1]
,[Kd_Bidang1]
,[Kd_Unit1]
,[Kd_Sub1]
,[Kd_UPB1]
,[No_Register1]
,[Invent]
,[No_SKGuna]
,[Kd_Penyusutan]
,[Kd_Data]
,[Kd_Alasan]
,[Log_User]
,[Log_entry]
,[Nm_Rekanan]
,[Alamat_Reakanan]
,[Tgl_Mulai]
,[Tgl_Selesai]
,[Kd_KA]
,[Kd_Koreksi]
,[IDData]
,[Kd_Aset8]
,[Kd_Aset80]
,[Kd_Aset81]
,[Kd_Aset82]
,[Kd_Aset83]
,[Kd_Aset84]
,[Kd_Aset85])
SELECT [IDPemda]
,[Kd_Id]
,[Kd_Riwayat]
,[Kd_Prov]
,[Kd_Kab_Kota]
,[Kd_Bidang]
,[Kd_Unit]
,[Kd_Sub]
,[Kd_UPB]
,[Kd_Aset1]
,[Kd_Aset2]
,[Kd_Aset3]
,[Kd_Aset4]
,[Kd_Aset5]
,[No_Register]
,[Kd_Pemilik]
,[Tgl_Dokumen]
,[No_Dokumen]
,[Tgl_Perolehan]
,[Tgl_Pembukuan]
,[Luas_M2]
,[Alamat]
,[Hak_Tanah]
,[Sertifikat_Tanggal]
,[Sertifikat_Nomor]
,[Penggunaan]
,[Asal_usul]
,[Harga]
,[Keterangan]
,[Tahun]
,[No_SP2D]
,[No_ID]
,[Kd_Kecamatan]
,[Kd_Desa]
,[Kd_Prov1]
,[Kd_Kab_Kota1]
,[Kd_Bidang1]
,[Kd_Unit1]
,[Kd_Sub1]
,[Kd_UPB1]
,[No_Register1]
,[Invent]
,[No_SKGuna]
,[Kd_Penyusutan]
,[Kd_Data]
,[Kd_Alasan]
,[Log_User]
,[Log_entry]
,[Nm_Rekanan]
,[Alamat_Reakanan]
,[Tgl_Mulai]
,[Tgl_Selesai]
,[Kd_KA]
,[Kd_Koreksi]
,[IDData]
,[Kd_Aset8]
,[Kd_Aset80]
,[Kd_Aset81]
,[Kd_Aset82]
,[Kd_Aset83]
,[Kd_Aset84]
,[Kd_Aset85]
FROM [DB_KABTASIK_2022_DISDIK].[dbo].[Ta_KIBAR]
ALTER TABLE Ta_KIBAR ENABLE TRIGGER ALL

ALTER TABLE Ta_KIBAHapus DISABLE TRIGGER ALL


INSERT INTO [DB_KABTASIK_2022_DRAFTDISDIK].[dbo].[Ta_KIBAHapus]
([IDPemda]
,[No_SK]
,[Tgl_SK]
,[Kd_Prov]
,[Kd_Kab_Kota]
,[Kd_Bidang]
,[Kd_Unit]
,[Kd_Sub]
,[Kd_UPB]
,[Kd_Aset1]
,[Kd_Aset2]
,[Kd_Aset3]
,[Kd_Aset4]
,[Kd_Aset5]
,[No_Register]
,[Kd_Pemilik]
,[Tgl_Perolehan]
,[Tgl_Pembukuan]
,[Luas_M2]
,[Alamat]
,[Hak_Tanah]
,[Sertifikat_Tanggal]
,[Sertifikat_Nomor]
,[Penggunaan]
,[Asal_usul]
,[Harga]
,[Keterangan]
,[Tahun]
,[No_SP2D]
,[No_ID]
,[Kd_Kecamatan]
,[Kd_Desa]
,[Invent]
,[Kd_Alasan]
,[Kd_Penyusutan]
,[No_SKGuna]
,[Kd_Data]
,[Kd_KA]
,[Log_User]
,[Log_entry]
,[No_BA]
,[Flag]
,[IDData]
,[Kd_Aset8]
,[Kd_Aset80]
,[Kd_Aset81]
,[Kd_Aset82]
,[Kd_Aset83]
,[Kd_Aset84]
,[Kd_Aset85])
SELECT [IDPemda]
,[No_SK]
,[Tgl_SK]
,[Kd_Prov]
,[Kd_Kab_Kota]
,[Kd_Bidang]
,[Kd_Unit]
,[Kd_Sub]
,[Kd_UPB]
,[Kd_Aset1]
,[Kd_Aset2]
,[Kd_Aset3]
,[Kd_Aset4]
,[Kd_Aset5]
,[No_Register]
,[Kd_Pemilik]
,[Tgl_Perolehan]
,[Tgl_Pembukuan]
,[Luas_M2]
,[Alamat]
,[Hak_Tanah]
,[Sertifikat_Tanggal]
,[Sertifikat_Nomor]
,[Penggunaan]
,[Asal_usul]
,[Harga]
,[Keterangan]
,[Tahun]
,[No_SP2D]
,[No_ID]
,[Kd_Kecamatan]
,[Kd_Desa]
,[Invent]
,[Kd_Alasan]
,[Kd_Penyusutan]
,[No_SKGuna]
,[Kd_Data]
,[Kd_KA]
,[Log_User]
,[Log_entry]
,[No_BA]
,[Flag]
,[IDData]
,[Kd_Aset8]
,[Kd_Aset80]
,[Kd_Aset81]
,[Kd_Aset82]
,[Kd_Aset83]
,[Kd_Aset84]
,[Kd_Aset85]
FROM [DB_KABTASIK_2022_DISDIK].[dbo].[Ta_KIBAHapus]
ALTER TABLE Ta_KIBAHapus ENABLE TRIGGER ALL

ALTER TABLE TA_KIB_B DISABLE TRIGGER ALL


INSERT INTO [DB_KABTASIK_2022_DRAFTDISDIK].[dbo].[Ta_KIB_B]
([IDPemda]
,[Kd_Prov]
,[Kd_Kab_Kota]
,[Kd_Bidang]
,[Kd_Unit]
,[Kd_Sub]
,[Kd_UPB]
,[No_Register]
,[Kd_Ruang]
,[Kd_Pemilik]
,[Merk]
,[Type]
,[CC]
,[Bahan]
,[Tgl_Perolehan]
,[Nomor_Pabrik]
,[Nomor_Rangka]
,[Nomor_Mesin]
,[Nomor_Polisi]
,[Nomor_BPKB]
,[Asal_usul]
,[Kondisi]
,[Harga]
,[Masa_Manfaat]
,[Nilai_Sisa]
,[Keterangan]
,[Tahun]
,[No_SP2D]
,[No_ID]
,[Tgl_Pembukuan]
,[Kd_Kecamatan]
,[Kd_Desa]
,[Invent]
,[No_SKGuna]
,[Kd_Penyusutan]
,[Kd_Data]
,[Log_User]
,[Log_entry]
,[Kd_Masalah]
,[Ket_Masalah]
,[Kd_KA]
,[No_SIPPT]
,[Dev_Id]
,[Kd_Hapus]
,[IDData]
,[Kd_Aset8]
,[Kd_Aset80]
,[Kd_Aset81]
,[Kd_Aset82]
,[Kd_Aset83]
,[Kd_Aset84]
,[Kd_Aset85]
,[No_Reg8]
,[Tg_Update8])
SELECT
[IDPemda]
,[Kd_Prov]
,[Kd_Kab_Kota]
,[Kd_Bidang]
,[Kd_Unit]
,[Kd_Sub]
,[Kd_UPB]
,[No_Register]
,[Kd_Ruang]
,[Kd_Pemilik]
,left([Merk], 50)
,left([Type], 50)
,left([CC], 50)
,left([Bahan], 50)
,[Tgl_Perolehan]
,left([Nomor_Pabrik], 50)
,left([Nomor_Rangka], 50)
,left([Nomor_Mesin], 50)
,left([Nomor_Polisi], 10)
,left([Nomor_BPKB], 50)
,left([Asal_usul], 50)
,[Kondisi]
,[Harga]
,[Masa_Manfaat]
,[Nilai_Sisa]
,left([Keterangan], 200)
,[Tahun]
,[No_SP2D]
,[No_ID]
,[Tgl_Pembukuan]
,[Kd_Kecamatan]
,[Kd_Desa]
,[Invent]
,[No_SKGuna]
,[Kd_Penyusutan]
,[Kd_Data]
,[Log_User]
,[Log_entry]
,[Kd_Masalah]
,[Ket_Masalah]
,[Kd_KA]
,[No_SIPPT]
,[Dev_Id]
,[Kd_Hapus]
,[IDData]
,[Kd_Aset8]
,[Kd_Aset80]
,[Kd_Aset81]
,[Kd_Aset82]
,[Kd_Aset83]
,[Kd_Aset84]
,[Kd_Aset85]
,[No_Reg8]
,[Tg_Update8]
FROM [DB_KABTASIK_2022_DISDIK].[dbo].[Ta_KIB_B]
WHERE [DB_KABTASIK_2022_DISDIK].[dbo].[Ta_KIB_B].[IDPemda] NOT IN (SELECT
[DB_KABTASIK_2022_DRAFTDISDIK].[dbo].[Ta_KIB_B].[IDPemda]
FROM [DB_KABTASIK_2022_DRAFTDISDIK].[dbo].[Ta_KIB_B])

ALTER TABLE TA_KIB_B ENABLE TRIGGER ALL

ALTER TABLE TA_KIB_C DISABLE TRIGGER ALL


INSERT INTO [DB_KABTASIK_2022_DRAFTDISDIK].[dbo].[Ta_KIB_C]
([IDPemda]
,[Kd_Prov]
,[Kd_Kab_Kota]
,[Kd_Bidang]
,[Kd_Unit]
,[Kd_Sub]
,[Kd_UPB]
,[No_Register]
,[Kd_Pemilik]
,[Tgl_Perolehan]
,[Bertingkat_Tidak]
,[Beton_tidak]
,[Luas_Lantai]
,[Lokasi]
,[Dokumen_Tanggal]
,[Dokumen_Nomor]
,[Status_Tanah]
,[Kd_Tanah1]
,[Kd_Tanah2]
,[Kd_Tanah3]
,[Kd_Tanah4]
,[Kd_Tanah5]
,[Kode_Tanah]
,[Asal_usul]
,[Kondisi]
,[Harga]
,[Masa_Manfaat]
,[Nilai_Sisa]
,[Keterangan]
,[Tahun]
,[No_SP2D]
,[No_ID]
,[Tgl_Pembukuan]
,[Kd_Kecamatan]
,[Kd_Desa]
,[Invent]
,[No_SKGuna]
,[Kd_Penyusutan]
,[Kd_Data]
,[Log_User]
,[Log_entry]
,[Kd_Masalah]
,[Ket_Masalah]
,[Kd_KA]
,[No_SIPPT]
,[Dev_Id]
,[Kd_Hapus]
,[IDData]
,[Kd_Aset8]
,[Kd_Aset80]
,[Kd_Aset81]
,[Kd_Aset82]
,[Kd_Aset83]
,[Kd_Aset84]
,[Kd_Aset85]
,[No_Reg8])
SELECT
[IDPemda]
,[Kd_Prov]
,[Kd_Kab_Kota]
,[Kd_Bidang]
,[Kd_Unit]
,[Kd_Sub]
,[Kd_UPB]
,[No_Register]
,[Kd_Pemilik]
,[Tgl_Perolehan]
,[Bertingkat_Tidak]
,[Beton_tidak]
,[Luas_Lantai]
,[Lokasi]
,[Dokumen_Tanggal]
,[Dokumen_Nomor]
,[Status_Tanah]
,[Kd_Tanah1]
,[Kd_Tanah2]
,[Kd_Tanah3]
,[Kd_Tanah4]
,[Kd_Tanah5]
,[Kode_Tanah]
,[Asal_usul]
,[Kondisi]
,[Harga]
,[Masa_Manfaat]
,[Nilai_Sisa]
,[Keterangan]
,[Tahun]
,[No_SP2D]
,[No_ID]
,[Tgl_Pembukuan]
,[Kd_Kecamatan]
,[Kd_Desa]
,[Invent]
,[No_SKGuna]
,[Kd_Penyusutan]
,[Kd_Data]
,[Log_User]
,[Log_entry]
,[Kd_Masalah]
,[Ket_Masalah]
,[Kd_KA]
,[No_SIPPT]
,[Dev_Id]
,[Kd_Hapus]
,[IDData]
,[Kd_Aset8]
,[Kd_Aset80]
,[Kd_Aset81]
,[Kd_Aset82]
,[Kd_Aset83]
,[Kd_Aset84]
,[Kd_Aset85]
,[No_Reg8]
FROM [DB_KABTASIK_2022_DISDIK].[dbo].[Ta_KIB_C]
WHERE [DB_KABTASIK_2022_DISDIK].[dbo].[Ta_KIB_C].[IDPemda] NOT IN
(SELECT [DB_KABTASIK_2022_DRAFTDISDIK].[dbo].[Ta_KIB_C].[IDPemda]
FROM [DB_KABTASIK_2022_DRAFTDISDIK].[dbo].[Ta_KIB_C])

ALTER TABLE TA_KIB_C ENABLE TRIGGER ALL

You might also like