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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy