Execute BCP Out from C#

[Priya Bange]

Hi Experts,

Could you pleases share a simple example . I have a table like this in SQL Server. I need to execute these query and output its data using bcp. withformat output_Getdate(). Please share how to execute the below in C# on a SQL Server instance.

SQL_Query SQL_Instance
SELECT Columns FROM Table1 LocalHost
SELECT Columns FROM Table2 LocalHost
SELECT Columns FROM Table3 LocalHost


bcp "Select Query from above table" queryout C:\Data\output_Getdate().txt -c -t, -S localhost -T

Continue reading...