Merge pull request #20041 from MicrosoftDocs/FromPublicRepo

huypub · web-flow · commit e764abb232df · 2021-08-20T15:26:40.000-07:00
Confirm merge from FromPublicRepo to master to sync with https://github.com/MicrosoftDocs/sql-docs (branch live)
diff --git a/docs/t-sql/statements/bulk-insert-transact-sql.md b/docs/t-sql/statements/bulk-insert-transact-sql.md
@@ -276,7 +276,8 @@ CREATE TABLE t_float(c1 FLOAT, c2 DECIMAL (5,4));
  The user wants to bulk import data into the `t_float` table. The data file, C:\t_float-c.dat, contains scientific notation **float** data; for example:
 
 ```input
-8.0000000000000002E-28.0000000000000002E-2
+8.0000000000000002E-2 8.0000000000000002E-2
+
 ```
 
 However, BULK INSERT cannot import this data directly into `t_float`, because its second column, `c2`, uses the `decimal` data type. Therefore, a format file is necessary. The format file must map the scientific notation **float** data to the decimal format of column `c2`.
@@ -537,4 +538,4 @@ For complete `BULK INSERT` examples including configuring the credential and ext
 - [INSERT &#40;Transact-SQL&#41;](../../t-sql/statements/insert-transact-sql.md)
 - [OPENROWSET &#40;Transact-SQL&#41;](../../t-sql/functions/openrowset-transact-sql.md)
 - [Prepare Data for Bulk Export or Import &#40;SQL Server&#41;](../../relational-databases/import-export/prepare-data-for-bulk-export-or-import-sql-server.md)
-- [sp_tableoption &#40;Transact-SQL&#41;](../../relational-databases/system-stored-procedures/sp-tableoption-transact-sql.md)
+- [sp_tableoption &#40;Transact-SQL&#41;](../../relational-databases/system-stored-procedures/sp-tableoption-transact-sql.md)
