If your application uses floating - point types , but your requirements can be met using an exact decimal type 如果應(yīng)用程序使用浮點(diǎn)類型,但是只要使用十進(jìn)制類型(
The string - to - decimal type conversions used in bulk insert follow the same rules as the transact - sql Bulk insert中使用的從字符串到十進(jìn)制類型的轉(zhuǎn)換所遵從的規(guī)則與transact - sql
The jdbc decimal type represents a fixed - precision decimal value that holds values of at least the specified precision Jdbc decimal類型表示固定精度的十進(jìn)制值,它保留指定精度以上的值。
Bulk insert supports string - to - decimal type conversion for strings representing numeric values that use scientific notation Bulk insert支持將使用科學(xué)計(jì)數(shù)法表示數(shù)值的字符串從字符串類型轉(zhuǎn)換為十進(jìn)制類型。
The jdbc decimal type also maps to the sql server money and smallmoney types , which are specific fixed - precision decimal types that are stored in 8 and 4 bytes , respectively Jdbc decimal類型還映射到sql server money類型和smallmoney類型,這是固定精度的特定decimal類型,分別以8個(gè)和4個(gè)字節(jié)進(jìn)行存儲(chǔ)。