April 21, 2021 at 4:25 am
as I'm not clear how to use bcp and bulk insert in the following cases, could you please give me an example on how to use it ? thanks!
April 21, 2021 at 9:58 am
1 use a query to extract the pieces you need, look at the QUERYOUT option of BCP for this.
2 there is no QUERYIN option, so if you only wanted to load part of the file you would have to import it all to a staging table first, then use a query to pull out the pieces you need and store them in the right table
3 lookup the syntax for BULK INSERT there is examples in the documentation on how to load a file using BULK INSERT
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply