I am using OSQL to create an output file from a SQL Statement. I am using the syntax that appends to an existing file but everytime it appends, there is a blank line between the previouse output file. Is their anyway to supress the blank line? Here is my code:
osql -S localhost -E -d master -w700 -Q "set nocount on; select '\"' + CAST(name AS Varchar(15)) + '\"', '\"' + CAST(type_desc AS varchar(10)) + '\"' from sys.tables" -h-1 -s "," >> edtest.txt