Start a new topic

Export More than 1 Million Rows

[This topic is migrated from our old forums. The original author name has been removed]

Hi! First time poster. I did some research on this but couldn't find a discussion. I am using the @export function and it seems to be limiting the number of export rows to 1 million. Is this the limit? Can I make it go higher? Thanks!
1 Comment

[This reply is migrated from our old forums.]

Re: Export More than 1 Million Rows
Hi Kevin, The @export command does not limit the number of rows in itself, but it is limited by the value in the *Max Rows* field or by the number specified by the *@set maxrows* command, if any. To ensure that all rows are exported, I suggest you use the @set maxrows command in the script, e.g.:: @export on; @export set ...; @set maxrows -1; select ... @export off; Best Regards, Hans