如何将足够多的列转换为十进制 [英] HOW TO CAST THE AMOUNT COLUMN TO DECIMAL

问题描述

(SELECT * from [DBO].[FormatIndianCurrency](SUM(VCR_AMOUNT)))

您能否告诉我如何将其转换为十进制..IM使用

CAN U PLS TELL ME HOW TO CAST THIS TO DECIMAL..IM UUSING

SELECT * from [DBO].[FormatIndianCurrency]

为大量字段输入印度式逗号.将字符串值转换为十进制值.

TO PUT INDIAN STYLE COMMA FOR AMOUNT FIELDS..WHEN I USE THIS CURRENCY FUNCTION IT IS RETURNING THE VALUE AS STRING..SO PLS TELL ME HOW TO CHANGE THE STRING VALUE TO DECIMAL VALUE.

推荐答案

请通过此链接进行操作.

SQL的十进制问题. [

please go through this link.

Decimal issue in SQL.[^]

p.s. Just do a search before you post your questions

Regards
Sebastian

看看:
投射和转换 [ CAST和CONVERT(Transact-SQL) [将int转换为十进制 [

Have a look:
CAST and CONVERT[^]
CAST and CONVERT (Transact-SQL)[^]

Cast int to decimal[^]

这篇关于如何将足够多的列转换为十进制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！