Hi Keshav, I am facing issues while loading CSV data with bcp. One of the column in CSV is having comma which is part of data and it is creating problems. Kindly suggest
Hi im new to sql, just wondering if theres a way to use bcp to export multiple tables into a text file or do i have to do it table by table? For my case all the tables are under the same schema
Thanks Keshav. This was really helpful
I get to learn a lot from you Keshav sir!!
Hi Keshav,
I am facing issues while loading CSV data with bcp.
One of the column in CSV is having comma which is part of data and it is creating problems.
Kindly suggest
Hi im new to sql, just wondering if theres a way to use bcp to export multiple tables into a text file or do i have to do it table by table? For my case all the tables are under the same schema
notice that -c overrides -f so by using -c you are not using the format file but the default character type
THANK YOU! I had been stumped by this exact thing.
Hi kesav After the Format in bcp command you specified nul why? you didn't Explain it?
Here you go..I have posted the vedio..refer my channel videos