September 19, 2016 at 7:06 am
I've run up against this one multiple times.
September 19, 2016 at 7:10 am
BrainDonor (9/16/2016)
RoNoS (9/16/2016)
Same as 'Select top 1000' default value. Or 'Edit top 200'. Where does those numbers come from?They are defaults within Tools/Options/SQL Server Object Explorer/Commands (in SSMS 2014 - may be elsewhere in other versions) and therefore configurable.
That works for the select TOP #. Is there something that will change the 1000 limit on the VALUES parameter of the insert command?
September 19, 2016 at 8:41 am
Iwas Bornready (9/19/2016)
BrainDonor (9/16/2016)
RoNoS (9/16/2016)
Same as 'Select top 1000' default value. Or 'Edit top 200'. Where does those numbers come from?They are defaults within Tools/Options/SQL Server Object Explorer/Commands (in SSMS 2014 - may be elsewhere in other versions) and therefore configurable.
That works for the select TOP #. Is there something that will change the 1000 limit on the VALUES parameter of the insert command?
Not as far as I've ever seen. I had to split a long excel-generated script last week because of this limitation, so I did have a good look to try and avoid that pain.
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply