Colleagues-
SQL CE 3.5. Running a multi-row insert query like:
INSERT INTO [Device] (Alias) SELECT 'Device1' UNION ALL SELECT 'Device2' UNION ALL ...
I read that there is no limit on query length, but I seem to remember running into a problem a while back where I getting runtime exceptions when inserting too many rows in a single query. Does anybody know of such a limit, or did I cut this memory from whole cloth?
Thanks!
- Edited by Tim Trese Friday, August 28, 2015 7:36 PM