Update Query in SQL Server 2000

Question

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Tara Kizer SSCommitted Points: 1789 More actions · Answer 1

That's the problem with float data type, it's just an approximation. If you want 1.25, then use decimal data type.

Nakul Vachhrajani SSChampion Points: 10294 More actions · Answer 2

Use the ROUND Function - for help & examples, refer BOL.

Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com

Follow me on
Twitter: @sqltwins

yeyint01 SSC Journeyman Points: 77 More actions · Answer 3

Thanks for your kindly help brother.

But in this case, I can't change data type of those fields. I'm not allowed to change the properties of table.

Is there other ways to solve the problem.

Best Regards .....

Tara Kizer SSCommitted Points: 1789 More actions · Answer 4

Nakul Vachhrajani (8/6/2010)
Use the ROUND Function - for help & examples, refer BOL.

The problem is with how it's stored.

yeyint01 SSC Journeyman Points: 77 More actions · Answer 5

Thanks to all brothers ...

I can solve the problem with all your suggestions.

by adding round function at Update Query like ....

UPDATE Products

SET ProductWeight = ROUND(@ProductWeight, 6)

Wishing you the best of everything ..... 🙂

Tara Kizer SSCommitted Points: 1789 More actions · Answer 6

I realize that ROUND has solved your immediate issue, however make sure you understand the float data type.

yeyint01 SSC Journeyman Points: 77 More actions · Answer 7

SSC Journeyman

Points: 77

August 7, 2010 at 1:16 am

Yes brother ... I will

yeyint01 SSC Journeyman Points: 77 More actions · Answer 8

Yes .... I am just a beginner in Database. Thanks a lot for guiding me ..... 🙂