Description
Properties
| Name | Value |
|---|---|
| Collation | SQL_Latin1_General_CP1_CI_AS |
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Schema Bound | False |
| Created | 10/8/2016 12:25:29 |
| Last Modified | 10/8/2016 12:25:29 |
Columns
| Key | Name | Description |
|---|---|---|
| importir_id | ||
| jenis_indentitas_id | ||
| jenis_indentitas_name | ||
| identitas_no | ||
| angka_pengenal_import_id | ||
| angka_pengenal_import_nama | ||
| angka_pengenal_import_nomor | ||
| no_skep | ||
| tanggal_skep | ||
| address | ||
| city | ||
| area_code | ||
| area_name | ||
| area_city | ||
| nama | ||
| nama_by_identitas |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.dv_importir
---XencX---with encryption
as
SELECT
importir_id,
cast(isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_1)),'') as int) as jenis_indentitas_id,
isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_2)),'') as jenis_indentitas_name,
isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_3)),'') as identitas_no,
cast(isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_4)),'')as int) as angka_pengenal_import_id,
isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_5)),'') as angka_pengenal_import_nama,
isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_6)),'') as angka_pengenal_import_nomor,
isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_7)),'') as no_skep,
cast(convert( date,isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_8)),null),121) as date ) as tanggal_skep,
isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_9)),'') as address,
isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_10)),'') as city,
isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_11)),'') as area_code,
isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_12)),'') as area_name,
isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_13)),'') as area_city,
isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_14)),'') as nama,
isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_15)),'') as nama_by_identitas
FROM dt_importir
GO
GO
create view dbo.dv_importir
---XencX---with encryption
as
SELECT
importir_id,
cast(isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_1)),'') as int) as jenis_indentitas_id,
isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_2)),'') as jenis_indentitas_name,
isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_3)),'') as identitas_no,
cast(isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_4)),'')as int) as angka_pengenal_import_id,
isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_5)),'') as angka_pengenal_import_nama,
isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_6)),'') as angka_pengenal_import_nomor,
isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_7)),'') as no_skep,
cast(convert( date,isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_8)),null),121) as date ) as tanggal_skep,
isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_9)),'') as address,
isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_10)),'') as city,
isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_11)),'') as area_code,
isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_12)),'') as area_name,
isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_13)),'') as area_city,
isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_14)),'') as nama,
isnull(CONVERT(varchar(MAX),DecryptByPassphrase('Ap4TanyaT4nyA MauT4uAja',field_15)),'') as nama_by_identitas
FROM dt_importir
GO