INSERT INTO dbo.TL_SYSROLE_LIMIT ( LIMIT_ID, ROLE_ID, LIMIT_VALUE, NOTES, MAKER_ID, AUTH_STATUS, CHECKER_ID, DATE_APPROVE, ISAPPROVE, BRANCH_ID, LIMIT_TYPE, LIMIT_PERCENT, DVDM_ID ) VALUES ( 'LMID00000001', -- LIMIT_ID - varchar(15) 'GDDV', -- ROLE_ID - varchar(15) 20000000, -- LIMIT_VALUE - decimal(18, 0) N'', -- NOTES - nvarchar(200) '', -- MAKER_ID - varchar(12) '', -- AUTH_STATUS - varchar(1) '', -- CHECKER_ID - varchar(12) GETDATE(), -- DATE_APPROVE - datetime '', -- ISAPPROVE - varchar(1) '', -- BRANCH_ID - varchar(15) 'PYC_DVMC', -- LIMIT_TYPE - varchar(15) NULL, -- LIMIT_PERCENT - decimal(18, 0) '' -- DVDM_ID - varchar(15) )