SQL Question
How to determine whether the number is float or integer in SQL Server?
I need to write this query in sql server:
IF isFloat(@value) = 1
BEGIN
PRINT 'this is float number'
END
ELSE
BEGIN
PRINT 'this is integer number'
END
Please help me out with this, thanks.
Recommended for you: Get network issues from WhatsUp Gold. Not end users.
Answer Source
declare @value float = 1
IF FLOOR(@value) <> CEILING(@value)
BEGIN
PRINT 'this is float number'
END
ELSE
BEGIN
PRINT 'this is integer number'
END
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download