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, 2476🔥, 0💬
Popular Posts:
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...