Post reply

blank lines in the output file

  • September 24, 2003 at 10:53 am

    #81055

    When running sql output to a file, SQL server likes to tack on 2 extra blank lines at the end with NOCOUNT ON. We have an application that takes the file and manipulates it. The problem is, the app does not like the blank lines at all!!! Is there a way to stop SQL server from doing this? I tried the both using OSQL and the Query Analyzer....

    Thanks

  • September 24, 2003 at 12:49 pm

    #475662

    Try bcp.

    --Jonathan



    --Jonathan

  • September 25, 2003 at 10:32 am

    #475848

    I am a little new at this SQL Server stuff.

    BCP works but isn't that for one table at a time?? What if I have a query with multiple tables?

    Thanks again for any help

  • September 25, 2003 at 10:46 am

    #475853

    quote:

    I am a little new at this SQL Server stuff.

    BCP works but isn't that for one table at a time?? What if I have a query with multiple tables?

    Thanks again for any help

    Any query with a result set will work with bcp, including stored procedures.

    --Jonathan



    --Jonathan

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply