[This topic is migrated from our old forums. The original author name has been removed]
This may related to the Max Rows setting. Will repost if it continues to be an issue.
Deleted by: DougK on Nov 29, 2012 12:40 AM
over 5 years ago
[This reply is migrated from our old forums.]
Re: Export to csv problem
The Max Rows setting in the SQL Commander also affects @export by default.
To override this insert the following in your script to export all rows in the result set:
@set maxrows -1;
-1 means unlimited while a positive number will export that many number of rows.