Exporting using BCP

Question

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 1

If you export, how can you overwrite a table?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

whitesql Ten Centuries Points: 1237 More actions · Answer 2

sorry, what I meant was.. to truncate the destination table first.

Is there a parameter I can use in bcp to truncate or format the destination table before inserting the data?

Thanks

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 3

No, there is no such parameter.

You would need to execute a TRUNCATE TABLE first before you call bcp.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

whitesql Ten Centuries Points: 1237 More actions · Answer 4

Ten Centuries

Points: 1237

July 14, 2014 at 2:32 am

Thank you! 🙂