how to use BCP in sql server through command prompt

Did you tried this:

https://www.youtube.com/watch?v=SQC9CglDxAw

https://www.youtube.com/watch?v=op_Hx4yelO4

https://www.youtube.com/watch?v=GWm9Ck_LB_I

Sorry did not understand ....

What is main sql server and local (gussing sql server running on your machine as local)?

Are you accessing sql server (assuming this a main server kind of live/prod) through your client instance.

hi manish,

But the file is in local system. i used my main sql server not my local .this suituation how can i do this .

Try this...

BCP yourdbName.dbo.yourtablename in "C:\Testfile\Sample.txt" -c -T -b100000 -S SQL2012 (--sql2012 is the instance name)

https://docs.microsoft.com/en-us/sql/relational-databases/import-export/import-and-export-bulk-data-by-using-the-bcp-utility-sql-server

Follow this links, this may helps,

1) https://docs.microsoft.com/en-us/sql/t-sql/statements/bulk-insert-transact-sql

2) https://docs.microsoft.com/en-us/sql/relational-databases/import-export/import-and-export-bulk-data-by-using-the-bcp-utility-sql-server