Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Decimals

Author  Topic 

Blug
Starting Member

9 Posts

Posted - 2011-03-30 : 08:13:39
Hey guys, was wondering how I insert decimals.

was thinking something like

create table herpderp(deci decimal(4,2))

That should only let you insert things like 9999.99 but no more right?? Because I've been trying it and it hasn't been working. I also tried swapped the numbers around and it still doesnt work.

Startin to bug me =(

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2011-03-30 : 08:30:45
Nope, decimal(4,2) would allow you to do only 99.99 (4 numbers, 2 to the right of the decical point).

Jim

Everyday I learn something that somebody else already knew
Go to Top of Page
   

- Advertisement -