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, 1608🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...