Timeline for What's the difference between "expression <=1." and "expression <= 1"?
Current License: CC BY-SA 3.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 1, 2015 at 13:05 | history | tweeted | twitter.com/#!/StackDBAs/status/616231045608947712 | ||
| S Jul 1, 2015 at 9:56 | history | suggested | MrWhite | CC BY-SA 3.0 |
Code formatting for clarity
|
| Jul 1, 2015 at 9:47 | review | Suggested edits | |||
| S Jul 1, 2015 at 9:56 | |||||
| S Jul 1, 2015 at 6:59 | history | suggested | Md Haidar Ali Khan | CC BY-SA 3.0 |
edit the text
|
| Jul 1, 2015 at 6:37 | comment | added | Martin Smith |
The lack of any 0 after the decimal point and the fact that decimal has higher datatype precedence than int so the constant would be implicitly cast anyway if needed would make me think that it is likely a typing error rather than deliberate.
|
|
| Jul 1, 2015 at 5:59 | review | Suggested edits | |||
| S Jul 1, 2015 at 6:59 | |||||
| Jul 1, 2015 at 5:27 | history | edited | Martin Smith | CC BY-SA 3.0 |
edited title
|
| Jul 1, 2015 at 2:02 | answer | added | mustaccio | timeline score: 18 | |
| Jul 1, 2015 at 1:55 | comment | added | Dan Guzman |
SQL Server treats the 1. literal as numeric(1,0) instead of integer due to the period. Perhaps that was specified in order to match the data type of the expression (a best practice). Personally, I'd specify 1.0 in that case.
|
|
| Jul 1, 2015 at 1:30 | review | First posts | |||
| Jul 1, 2015 at 6:28 | |||||
| Jul 1, 2015 at 1:30 | history | asked | Pete Forester | CC BY-SA 3.0 |