By using a format file, you can customize the data file created by
bcp or specify complex field layouts for data loads. There are two ways to create a format file: by using interactive
bcp and by using the
If you do not specify one of the
–w data type format switches,
bcp (in or out) prompts you for the following information for each column in the data set:
File storage type
bcp offers a default for each of these ...