|
Without Google answer this.
What is the biggest value you can insert in below table column ?
ColumnName Datatype
ChargePercentage decimal(3,2)
Sometime assumptions can be deceiving.
[Edit]
It was in one of my application I am currently developing. While making column for percentage I thought max percentage can be 100.00 so column will need max 3 digits followed by dot followed by two more digits. Sometimes mind plays trick on you. Today I broke it trying to insert 10.00 in it until I noticed my mistake.
Zen and the art of software maintenance : rm -rf *
Maths is like love : a simple idea but it can get complicated.
modified 21-Jun-16 2:09am.
|
|
|
|
|
|
|
Depends on the language.
But for SQL that would be 9.99
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
See.... To cover myself I wasn't going to reveal the database
|
|
|
|
|
Been working on MySql 4 have you?
|
|
|
|
|
It helps sometimes to google the documentation...
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
... such stuff as dreams are made on
|
|
|
|
|
You could declare the column to hold a byte and then store "War and Peace" in it.
Not the string. The whole feckin book.
Apparently, SQL allows that.
|
|
|
|
|
|
All this moaning and groaning. Just suck it up and remember there are people with real problems in the world. We English have to face our Welsh neighbours and friends tomorrow and find some plausible excuse for coming second to them in God's own sport. (I take it for granted that you know God is English, of course).
I am not a number. I am a ... no, wait!
|
|
|
|
|
Sport?
Soapbox!
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
It's not a sport! Just a pathetic excuse to drink too much, behave like an a**hole and fight with other like-"minded" neanderthals!
Who the hell in their right mind cares about 22 millionaires ruining a perfectly good lawn while chaising a bloated pig skin anyway?
Come to think of it: It should be in the Soapbox all the same!
Anything that is unrelated to elephants is irrelephant Anonymous
- The problem with quotes on the internet is that you can never tell if they're genuine Winston Churchill, 1944
- I'd just like a chance to prove that money can't make me happy. Me, all the time
modified 21-Jun-16 6:33am.
|
|
|
|
|
I think the average neanderthal would not agree that that sort of behaviour is typical for them.
It probably takes a more modern idiot to do all of that.
|
|
|
|
|
Johnny J. wrote: It's not a sport! Just a pathetic excuse to drink too much, behave like an a**hole and fight with other like-"minded" neandethals! Oh, well that's all right, then.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
I equate soccer/football and any sport that involves a ball or two ( ) to the game of golf. You basically move a ball in a direction, and then go after it -- over, and over, and over, and over.
And in some areas around the world, fans get hurt and some, eve die for this.
|
|
|
|
|
Yes!
|
|
|
|
|
I believe Roy made a tactical decision to come second so as to play a lesser team in the next round. Smart.
|
|
|
|
|
That one game didn't the remember Russians hooligans the queen Welsh didn't clobber soccer the one plausible excuse for a suck it up and remember God's own one Holy Spirit the one with Real problems in the world.
|
|
|
|
|
Never mind sport. It's really bad here. It's the shortest day of the year and colder than Scottish summer
|
|
|
|
|
RossMW wrote: colder than Scottish summer And how cold is that then?
|
|
|
|
|
|
If it's any consolation, it's the Longest Day today and it's only 17C here...
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Sorry No. I will not be denied my major first world problems!
|
|
|
|
|
My Casio Scientific Calculator just updated itself to Windows 10 and now the solar power panel isn't working.
|
|
|
|