Start a new topic

Export to csv problem

[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
1 Comment

[This reply is migrated from our old forums.]

Re: Export to csv problem
Doug, 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. Regards Roger