Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The BCP data file contains the set of data type values that are exported from the database server or imported into the server. The structure of the data file is represented in the following format.
-
Data = BigInt / Binary / Bit / Char / CLRUDT / Date / DateTime / DateTime2 Data =/ DateTimeOffset / Decimal / Float / Image / Int / Money / NChar / NText Data =/ Numeric / NVarChar / Real / SmallDateTime / SmallInt / SmallMoney Data =/ Text / Time / TimeStamp / TinyInt / UniqueIdentifier / VarBinary Data =/ VarChar / XML / NULL Row = *(Data FieldTerminator) Data ;The last Data does not have a FieldTerminator DataFile = %xFF %xFE *Row RowTerminator
In this format, each repeated Row contains the same set of Data columns.