Posted by Erland Sommarskog on 10/06/63 11:27

(yanakal@gmail.com) writes:
> I'm using isql to query data and output the same to a flat file.
> The isql has the following command options ' -h-1 -w500 -n -b -s"" '.
> In the SQL_CODE, the first two lines before the select statement are
> use dbname
> set nocount on
> go
> When I run this, an additional blank line is put into the output file.
> Actually, there are two lines after the last result set in the output
> file. This file is being fed into another system and the blank line is
> causing validation issues.
> How can I supress this blank line?

You would have to pipe the output to something that strips the last line.

But is there any special reason you use ISQL and not BCP?



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Error : Difference of two datetime columns caused overflow at runtime.
• Prev in forum: Re: searching a list of tables, derived from another table
• Thread view: Re: iSQL - Blank line at the end of the iSql output file

[Reply to this message]