sukumar s

sukumar s

  • NA
  • 25
  • 20k

SQL Data Types problem

Feb 3 2015 7:23 AM
Hi Friends,
I have two fileds in sql server.
1.tran_amt numeric(16,0) 
2.amout numeric(12,2) 
I have select the amount column and update to the tran_amount column.
My problem is tran_amount should be came roundable value. But I want exact value(with points) 
ex:
amout=1467.95
update A set tran_amount=@amout
Result : 1468
Expected Result : 1467.95 
Please help me on this... 

Answers (6)