Skip to content

Instantly share code, notes, and snippets.

@koi8-r

koi8-r/floats.sql

Last active August 29, 2015 14:13
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save koi8-r/b905271768e300120a99 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save koi8-r/b905271768e300120a99 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
floats.sql
DECLARE @f0 float(53) ;
DECLARE @f1 real ;
SET @f0 = 10.99 ;
SET @f1 = 3.0513 ;
SELECT @f0 + @f1;
SELECT CAST(@f0 AS real) + @f1;
SELECT CAST(@f0 AS numeric(38,2)) + CAST(@f1 AS numeric(38,2));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment