문자열로 '01000000000' 받아서요
decimal(11,6)로 변환하려면
어떻게 해야하나요?
'01000000000' => 1000,000000
이렇게 하려면 어떻게해야하나요?
ex)
밑에 처럼했더니 에러만 나네요 ㅠㅠ
SELECT convert(decimal(11,6),'01000000000')
번호사이에 있는게 "," 맞나요? 아님 쩜인가요? 1> declare @xyz varchar(20) 2> select @xyz = '01000000000' 3> 4> SELECT convert(decimal(11,6), convert(int,@xyz)/1000000) 5> SELECT convert(decimal(17,6),@xyz) 6> SELECT convert(decimal(11,0),@xyz) 7> SELECT convert(int, @xyz) 8> SELECT convert(numeric, @xyz) 9> SELECT convert(float, @xyz) 10> SELECT convert(money, @xyz) 11> go (1 row affected)
-------------- 1000.000000
(1 row affected)
-------------------- 1000000000.000000
-------------- 1000000000
----------- 1000000000
--------------------- 1000000000
------------------------ 1,000,000,000.00