Acara
19 Nov, 23 - 21 Nov, 23
Bergabunglah dengan sesi online di Microsoft Ignite yang dibuat untuk memperluas keterampilan Anda dan membantu Anda mengatasi masalah kompleks saat ini.
Daftar sekarangBrowser ini sudah tidak didukung.
Mutakhirkan ke Microsoft Edge untuk memanfaatkan fitur, pembaruan keamanan, dan dukungan teknis terkini.
Stream Name:
BulkLoadBCP
Stream Function:
Describes the format of bulk-loaded data through the "INSERT BULK" T-SQL statement. The format is a COLMETADATA token (section 2.2.7.4) describing the data being sent, followed by multiple ROW tokens (section 2.2.7.20), ending with a DONE token (section 2.2.7.6). The stream is equivalent to that produced by the server if it were sending the same rowset on output.
Stream Comments:
Packet header type is 0x07.
This message sent to the server contains bulk data to be inserted. The client MUST have previously notified the server where this data is to be inserted. For more information about the INSERT BULK syntax, see [MSDN-INSERT].
A sample BulkLoadBCP message is in section 4.12.
Stream-Specific Rules:
BulkLoad_METADATA = COLMETADATA BulkLoad_ROW = ROW BulkLoad_DONE = DONE
Submessage Definition:
BulkLoadBCP = BulkLoad_METADATA *BulkLoad_ROW BulkLoad_DONE
Note that for INSERT BULK operations, XMLTYPE is to be sent as NVARCHAR(N) or NVARCHAR(MAX) data type. An error is produced if XMLTYPE is specified.
INSERT BULK operations for data type UDTTYPE is not supported. Use VARBINARYTYPE to insert instances of User Defined Types.
INSERT BULK operations do not support type specifications of DECIMALTYPE and NUMERICTYPE. To insert these data types, use DECIMALNTYPE and NUMERICNTYPE.
Acara
19 Nov, 23 - 21 Nov, 23
Bergabunglah dengan sesi online di Microsoft Ignite yang dibuat untuk memperluas keterampilan Anda dan membantu Anda mengatasi masalah kompleks saat ini.
Daftar sekarang