I am not very experienced in directly interfacing JMP to SQL, however, here is a response from @vince_faller Writing to an SQL database that writes multiple values.
dbc = Create Database Connection("DRIVER=SQL SERVER;SERVER=fake_database;Database=Test_DB");
sqlreturn = Execute SQL(dbc,
"INSERT INTO [Test_DB].[dbo].[fake]
VALUES
('TestSQLinsert'
,1
,1
,'JMP'
,14.14
,14.14
,1
,'JMP'
,'JMP'
,'JMP'
,14
,14
)"
);
close database connection(dbc);
Jim