<div>
<div class="content wysiwyg-content">
OSQL - problem a line break is occuring in the output.<br />
<br />
In certain records line breaks are introduced into the output while using osql<br />
The data in the database is free from line breaks and carriage returns and all other non alphanumeric characters.<br />
<br />
I've changed the &quot;maximum characters per column&quot; in query analyser to 8000 and tried increasing the dos window size to 1000. But that doesn't work.<br />
<br />
If I use query analyser with results to file the data output is fine.<br />
<br />
I'm using SQL server 2000 <br />
<br />
The OSQL is :-<br />
osql -S ServerName -d DatabaseName -E -w1200 -Q DatabaseName.dbo.StoredPro<wbr />cedureName<wbr /> -o C:\OutFile.csv<br />
<br />
The stored procedure (StoredProcedureName) queries various tables and uses a cursor with print to output the data as comma separated variables. This output is 910 characters long including the commas &nbsp;<br />

</div>
</div>


OSQL - problem a line break is occuring in the output.

In certain records line breaks are introduced into the output while using osql
The data in the database is free from line breaks and carriage returns and all other non alphanumeric characters.

I've changed the "maximum characters per column" in query analyser to 8000 and tried increasing the dos window size to 1000. But that doesn't work.

If I use query analyser with results to file the data output is fine.

I'm using SQL server 2000 

The OSQL is :-
osql -S ServerName -d DatabaseName -E -w1200 -Q DatabaseName.dbo.StoredProcedureName -o C:\OutFile.csv

The stored procedure (StoredProcedureName) queries various tables and uses a cursor with print to output the data as comma separated variables. This output is 910 characters long including the commas  


OSQL data formating problem

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.