Row Limit on INSERT ... SELECT ... UNION ALL Statements?

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
August 28th, 2015 4:31pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics