INSERT INTO [New2Hawaii].[dbo].[NH_MAST]
([NH_MODID]
,[NH_RCDTYP1]
,[NH_RCDTYP2]
,[NH_RCDTYP3]
,[NH_RCDT
,[NH_TEXT3]
,[NH_TEXT4]
,[NH_TEXT5]
,[NH_TEXT6]
,[NH_TEXT7]
,[NH_PIC1]
,[NH_PIC2]
,[NH_PIC3]
,[NH_PIC4]
,[NH_PIC5]
,[NH_PIC6]YP4]
,[NH_DTAKEY1]
,[NH_DTAKEY2]
,[NH_DTAKEY3]
,[NH_DTAKEY4]
,[NH_DTAKEY5]
,[NH_STATUS]
,[NH_TEXT1]
,[NH_TEXT2]
,[NH_PIC7]
,[NH_STRDT]
,[NH_EXPDT]
,[NH_PRICE]
,[NH_NUM1]
,[NH_NUM2]
,[NH_NUM3]
,[NH_NUM4]
,[NH_NUM5]
,[NH_NUM6]
,[NH_NUM7]
,[NH_NUM8]
,[NH_NUM9]
,[USER_ID]
,[TIME_STAMP])
VALUES
(<NH_MODID, numeric(5,0),>
,<NH_RCDTYP1, nvarchar(max),>
,<NH_RCDTYP2, nvarchar(max),>
,<NH_RCDTYP3, nvarchar(max),>
,<NH_RCDTYP4, nvarchar(max),>
,<NH_DTAKEY1, nvarchar(50),>
,<NH_DTAKEY2, nvarchar(50),>
,<NH_DTAKEY3, nvarchar(50),>
,<NH_DTAKEY4, nvarchar(50),>
,<NH_DTAKEY5, nvarchar(50),>
,<NH_STATUS, char(10),>
,<NH_TEXT1, nvarchar(500),>
,<NH_TEXT2, nvarchar(500),>
,<NH_TEXT3, nvarchar(500),>
,<NH_TEXT4, nvarchar(500),>
,<NH_TEXT5, nvarchar(500),>
,<NH_TEXT6, nvarchar(500),>
,<NH_TEXT7, nvarchar(500),>
,<NH_PIC1, nvarchar(500),>
,<NH_PIC2, nvarchar(500),>
,<NH_PIC3, nvarchar(500),>
,<NH_PIC4, nvarchar(500),>
,<NH_PIC5, nvarchar(500),>
,<NH_PIC6, nvarchar(500),>
,<NH_PIC7, nvarchar(500),>
,<NH_STRDT, date,>
,<NH_EXPDT, date,>
,<NH_PRICE, numeric(5,2),>
,<NH_NUM1, nvarchar(100),>
,<NH_NUM2, nvarchar(100),>
,<NH_NUM3, nvarchar(100),>
,<NH_NUM4, nvarchar(100),>
,<NH_NUM5, nvarchar(100),>
,<NH_NUM6, nvarchar(100),>
,<NH_NUM7, nvarchar(100),>
,<NH_NUM8, nvarchar(100),>
,<NH_NUM9, nvarchar(100),>
,<USER_ID, datetime,>
,<TIME_STAMP, datetime,>)