TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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...
Reply
Answers (
6
)
Manage SQL Server Database
Inner Join Vs Outer Join vs Cross Join