2012-08-17

TSQL - Scientific notation arithmetic warning


select 2E
union all select 3E
union all SELECT 2E-3E --> Doing 2E-3, ingnoring the extra "E".
union all select (2E)-(3E)
;
/*
2
3
0.002
-1
*/




No comments:

Post a Comment