T-sql – determine if value is integer

by

Here’s a blog post describing the creation of an IsInteger UDF.

Basically, it recommends adding '.e0' to the value and using IsNumeric. In this way, anything that already had a decimal point now has two decimal points, causing IsNumeric to be false, and anything already expressed in scientific notation is invalidated by the e0.

More Related Contents:

  1. Date conversion and culture: Difference between DATE and DATETIME
  2. How to determine the field value which can not convert to (decimal, float,int) in SQL Server
  3. How do I create a unique constraint that also allows nulls?
  4. How do I get list of all tables in a database using TSQL?
  5. Get first day of week in SQL Server
  6. What is the significance of 1/1/1753 in SQL Server?
  7. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
  8. Escape a string in SQL Server so that it is safe to use in LIKE expression
  9. Insert Update trigger how to determine if insert or update
  10. SQL time difference between two dates result in hh:mm:ss
  11. What is the best way to truncate a date in SQL Server?
  12. Dynamic SQL (passing table name as parameter)
  13. SQL Server: Difference between PARTITION BY and GROUP BY
  14. How do you truncate all tables in a database using TSQL?
  15. Understanding SQL Server LOCKS on SELECT queries
  16. SQL Server: How to select all days in a date range even if no data exists for some days
  17. SQL – The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
  18. TSQL: How to convert local time to UTC? (SQL Server 2008)
  19. T-SQL Dynamic SQL and Temp Tables
  20. Efficient ISNUMERIC() replacements on SQL Server?
  21. Find non-ASCII characters in varchar columns using SQL Server
  22. How can I determine in SQL Server if a dateTime range overlaps another
  23. How do you change the datatype of a column in SQL Server?
  24. SQL Server Query – groupwise multiplication
  25. SELECT INTO a table variable in T-SQL
  26. T-SQL query to show table definition?
  27. How can I insert binary file data into a binary SQL field using a simple insert statement?
  28. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  29. Include missing months in Group By query
  30. What are row, page and table locks? And when they are acquired?

Leave a Comment