Student

chokka

<div>
Great , very helpful ..<br />
<br />
Just trying to pass a stored procedure with paramater ..
</div>


Great , very helpful ..

Just trying to pass a stored procedure with paramater ..

<div>
<div class="content wysiwyg-content">
How to export sql to csv using BCP?<br />
<br />
1) My sql server does not have office. So we are not planning to use SSIS package.<br />
<br />
2) I have a stored procedure which has input parameter of getting the file name.<br />
<br />
SP returns 25 columns. We wanted to save the data in a csv file. We will have another SP which will send email alert with this csv file attached to the email distribution list.<br />
<br />
How to export a stored procedure which has input parameter to csv file?
</div>
</div>


How to export sql to csv using BCP?

1) My sql server does not have office. So we are not planning to use SSIS package.

2) I have a stored procedure which has input parameter of getting the file name.

SP returns 25 columns. We wanted to save the data in a csv file. We will have another SP which will send email alert with this csv file attached to the email distribution list.

How to export a stored procedure which has input parameter to csv file?

How to export sql to csv using BCP?

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.