/** Object: Sequence [dbo].[SEQ_COM_EAILOG] Script Date: 2019-05-16 오전 9:13:29 **/
CREATE SEQUENCE [dbo].[SEQ_SCP_MST_LOCATION]
AS [bigint]
START WITH 100
INCREMENT BY 1
MINVALUE 1
MAXVALUE 999999999999999999
CYCLE
CACHE
GO
INSERT (
SITE_CODE
,LOCATION_SEQ
,LOCATION_CODE
,LOCATION_NAME
,PLANT_ID
,FACTORY_ID
,STORAGE_ID
,VALID_YN
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
)
VALUES
(
B.SITE_CODE
,NEXT VALUE FOR [SEQ_SCP_MST_LOCATION]
,B.LOCATION_CODE
,B.LOCATION_NAME
,B.PLANT_ID
,B.FACTORY_ID
,B.STORAGE_ID
,B.VALID_YN
,B.CREATED_BY
,B.[CREATED_DATE]
,B.LAST_UPDATED_BY
,B.LAST_UPDATE_DATE
)
Bang-Ga