Search results

  1. N

    Insert multiple rows values with MS Access

    Use the query like this: INSERT INTO Product (Code,Name,IsActive,CreatedById,CreatedDate ) SELECT * FROM (SELECT '10001000' AS Code,'Blackburn sunglasses' AS Name,1 AS IsActive,1 AS CreatedById,'2/20/2015 12:23:00 AM' AS CreatedDate FROM Product UNION SELECT '10005200' AS Code,'30 panel...
Back
Top Bottom