Collections:
Exact Numeric Literals in SQL Server Transact-SQL
What are exact numeric literals supported in SQL Server Transact-SQL?
✍: FYIcenter.com
Exact numeric literals in Transact-SQL are numbers written in standard signed decimal formats.
Exact numeric literals are used to provide values to exact numeric variables or table columns like INTEGER, DECIMAL(8,2), MONEY, etc.
Exact numeric literals are also used in exact numeric operations in expressions and exact numeric arguments in functions.
Here are some simple rules on how to write string literals:
Here are some example on how to write exact numeric literals:
-- Identical exact numeric literals PRINT 9; PRINT 9.; -- Identical exact numeric literals PRINT 9.0; PRINT +9.0; PRINT 09.0; -- Different exact numeric literals PRINT 9; PRINT 9.0; PRINT 9.00; -- Exact numeric literals in operation PRINT 1.0/3;
⇒ Approximate Numeric Literals in SQL Server Transact-SQL
⇐ Unicode Character String Literals in SQL Server Transact-SQL
2017-05-05, 2475🔥, 0💬
Popular Posts:
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...