Details
-
Type:
Bug
-
Status: Resolved
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 1.4.0
-
Component/s: None
-
Labels:None
-
Release Note:Committed. Thanks Patrick!
Description
SQLServer 2005 doesn't support the following syntax:
INSERT INTO tableName (col1, col2, col3)
VALUES (?, ?, ?), (?, ?, ?), (?, ?, ?), ...
Instead it supports
INSERT INTO tableName (col1, col2, col3)
(SELECT ?, ?, ?) UNION ALL
(SELECT ?, ?, ?) UNION ALL
(SELECT ?, ?, ?) ...