<div>
bcp Database.dbo.Table out c: Filename.txt -n -S Server -U Username -P Password -eC: error.txt<br />

</div>


bcp Database.dbo.Table out c: Filename.txt -n -S Server -U Username -P Password -eC: error.txt


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I'm now trying to use bcp command to output a MS SQL table into a &quot;fixed column&quot; format text file. &nbsp;Could anyone help me on this and give me an example for quick resolution? &nbsp;Thanks a lot.<br />
<br />
Cheers<br />
Stanley
</div>
</div>


Hi,

I'm now trying to use bcp command to output a MS SQL table into a "fixed column" format text file.  Could anyone help me on this and give me an example for quick resolution?  Thanks a lot.

Cheers
Stanley

MS SQL syntax : How to use bcp to output a fixed column data file ?

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.