Best equivalent for IsInteger in SQL Server

by

Late entry that handles negative

ISNUMERIC(zipcode + '.0e0') --integer
ISNUMERIC(zipcode + 'e0')  --decimal

For more see this

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. How do I UPDATE from a SELECT in SQL Server?
  3. Get top 1 row of each group
  4. How to return only the Date from a SQL Server DateTime datatype
  5. CROSS JOIN vs INNER JOIN in SQL
  6. Referring to a Column Alias in a WHERE Clause
  7. Function vs. Stored Procedure in SQL Server
  8. Generate a resultset of incrementing dates in TSQL
  9. converting Epoch timestamp to sql server(human readable format)
  10. Better techniques for trimming leading zeros in SQL Server?
  11. How do I split a delimited string so I can access individual items?
  12. Common Table Expression, why semicolon?
  13. What’s the best way to select the minimum value from several columns?
  14. T-SQL split string based on delimiter
  15. Counting DISTINCT over multiple columns
  16. Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?
  17. Why use Select Top 100 Percent?
  18. How to check if a stored procedure exists before creating it
  19. Correct use of transactions in SQL Server
  20. Find the real column name of an alias used in a view?
  21. Stored procedure that exports data into csv files only exports to one file
  22. Get Start and End Date from Week Number SQL Server
  23. How to get the identity of an inserted row?
  24. Get the last day of the month in SQL
  25. How to create a pivot query in sql server without aggregate function
  26. SQL take just the numeric values from a varchar
  27. SQL Server FOR XML Path make repeating nodes
  28. Cumulative Total in MS Sql server [duplicate]
  29. Why is RAND() not producing random numbers?
  30. Should every SQL Server foreign key have a matching index? [closed]

Leave a Comment