Collections:
Approximate Numeric Literals in SQL Server Transact-SQL
What are approximate numeric literals supported in SQL Server Transact-SQL?
✍: FYIcenter.com
Approximate numeric literals in Transact-SQL are numbers written in scientific notation formats.
Approximate numeric literals are used to provide values to approximate numeric variables or table columns like LOAT(24), DOUBLE PRECESSION, etc.
Approximate numeric literals are also used in approximate numeric operations in expressions and approximate numeric arguments in functions.
Here are some simple rules on how to write approximate numeric literals:
Here are some example on how to write exact numeric literals:
-- Identical approximate numeric literals PRINT 9E0; PRINT 9E; PRINT 9E+; PRINT 9E-; -- Approximate numeric literal as function argument PRINT SQRT(2.5E+1);
⇒ Binary Literals in SQL Server Transact-SQL
⇐ Exact Numeric Literals in SQL Server Transact-SQL
2017-05-05, 1604🔥, 0💬
Popular Posts:
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...