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 | 8/3/2020 10:14:08 |
| Last Modified | 8/3/2020 10:14:08 |
Columns
| Key | Name | Description |
|---|---|---|
| teknisi_id | ||
| teknisi_code | ||
| teknisi_name | ||
| create_date | ||
| create_by | ||
| modify_date | ||
| modify_by |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create VIEW dbo.view_ms_teknisi
AS
SELECT dt_ms_teknisi.teknisi_id
, dt_ms_teknisi.teknisi_code
, dt_ms_teknisi.teknisi_name
, dbo.dt_ms_teknisi.create_date
, users_create.username AS create_by
, dbo.dt_ms_teknisi.modify_date
, users_modify.username AS modify_by
FROM dbo.dt_ms_teknisi
LEFT OUTER JOIN dbo.users AS users_create ON dbo.dt_ms_teknisi.create_by = users_create.id
LEFT OUTER JOIN dbo.users AS users_modify ON dbo.dt_ms_teknisi.modify_by = users_modify.id
GO
GO
create VIEW dbo.view_ms_teknisi
AS
SELECT dt_ms_teknisi.teknisi_id
, dt_ms_teknisi.teknisi_code
, dt_ms_teknisi.teknisi_name
, dbo.dt_ms_teknisi.create_date
, users_create.username AS create_by
, dbo.dt_ms_teknisi.modify_date
, users_modify.username AS modify_by
FROM dbo.dt_ms_teknisi
LEFT OUTER JOIN dbo.users AS users_create ON dbo.dt_ms_teknisi.create_by = users_create.id
LEFT OUTER JOIN dbo.users AS users_modify ON dbo.dt_ms_teknisi.modify_by = users_modify.id
GO
Depends On
2Used By
No items found