Approximate Numeric Literals in SQL Server Transact-SQL
What are approximate numeric literals supported in SQL Server Transact-SQL?
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);
2017-05-05, 1097👍, 0💬
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
What is Microsoft SQL Server in SQL Server? Microsoft SQL Server is a relational database management...