問(wèn)題描述

假設(shè)我有一個(gè)德國(guó)數(shù)字格式1,00"的數(shù)字，在 en-US 語(yǔ)言環(huán)境中等于 1.0.

Let's say I have a number in the german number format "1,00" which is equal to 1.0 in the en-US locale.

是否有內(nèi)置的方法可以將 T-SQL 中的此文本轉(zhuǎn)換為相應(yīng)的數(shù)字?似乎 CONVERT 和 CAST 只接受帶有 '.' 的數(shù)字.作為小數(shù)點(diǎn)分隔符，我認(rèn)為沒有辦法告訴他們.

Is there a built-in way to convert this text in T-SQL to the corresponding number? It seems like CONVERT and CAST accept only numbers with '.' as the decimal separator and I see no way to tell them otherwise.

我正在考慮簡(jiǎn)單地用 '.' 替換 ','但是如果我有一個(gè)像1.000,00"這樣的帶有千位分隔符的德語(yǔ)數(shù)字，這會(huì)變得很難看.

I was thinking about simply replacing ',' with '.' but this gets ugly if I have a german number with thounsands separator like "1.000,00".

在檢索到錯(cuò)誤"的 SQL 結(jié)果后進(jìn)行轉(zhuǎn)換不是一種選擇.

Doing the conversion after retrieving the "wrong" SQL result is not an option.

推薦答案

如果您想在 SQL Server 中執(zhí)行此操作，則必須創(chuàng)建一個(gè)將字符串作為參數(shù)的 CLR 存儲(chǔ)過(guò)程/用戶定義函數(shù)并返回您想要的數(shù)字類型.您可能還需要使用一個(gè)參數(shù)來(lái)指示您可能希望使用哪些區(qū)域名稱(例如 en-US)來(lái)指示用于確定解析模式的區(qū)域性.

If you want to do this inside SQL Server, then you will have to create a CLR stored procedure/user-defined function which will take the string as a parameter and return the numeric type that you desire. You might also want to take a parameter that indicates what region names (en-US for example) you might want to use to indicate the culture to use for determining the parsing pattern.

然后，在代碼中，您將在 Double/Decimal/Int32 上調(diào)用 TryParse 方法并使用適當(dāng)?shù)?CultureInfo 來(lái)指示解析模式.您可以循環(huán)瀏覽其中的一堆，或使用其他一些信息來(lái)確定正確的模式.

Then, in the code, you would call the TryParse method on Double/Decimal/Int32 and use the appropriate CultureInfo to indicate the parse pattern. You can cycle through a bunch of them, or use some other information to determine the right pattern.

這篇關(guān)于如何將具有本地化數(shù)字格式的文本轉(zhuǎn)換為 MS SQL Server 中的數(shù)字?的文章就介紹到這了，希望我們推薦的答案對(duì)大家有所幫助，也希望大家多多支持html5模板網(wǎng)！