How to get a float result by dividing two integer values using T-SQL?

by

The suggestions from stb and xiowl are fine if you’re looking for a constant. If you need to use existing fields or parameters which are integers, you can cast them to be floats first:

SELECT CAST(1 AS float) / CAST(3 AS float)

or 

SELECT CAST(MyIntField1 AS float) / CAST(MyIntField2 AS float)

More Related Contents:

  1. Using merge..output to get mapping between source.id and target.id
  2. SQL Server, How to set auto increment after creating a table without data loss?
  3. How can I truncate a datetime in SQL Server?
  4. Which are more performant, CTE or temporary tables?
  5. Using RegEx in SQL Server
  6. Errors: “INSERT EXEC statement cannot be nested.” and “Cannot use the ROLLBACK statement within an INSERT-EXEC statement.” How to solve this?
  7. Import Excel spreadsheet columns into SQL Server database
  8. SqlServer: Login failed for user
  9. SQL Server 2008 Empty String vs. Space
  10. How to set a default value for an existing column
  11. How to drop column with constraint?
  12. SQL Server: combining multiple rows into one row
  13. SQL Server Query: Fast with Literal but Slow with Variable
  14. How to add xml encoding to xml Output in SQL Server
  15. How do I find a stored procedure containing ?
  16. SQL Server GUID sort algorithm. Why?
  17. An attempt to login using SQL authentication failed
  18. SQL Server, the misleading XLOCK & optimizations
  19. How to create the linked server for SQL Server 2008 where we have the database from 2000 and 2005
  20. How to find SQL Server running port?
  21. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  22. Changing SQL Server collation to case insensitive from case sensitive?
  23. Unable to login to SQL Server + SQL Server Authentication + Error: 18456
  24. What’s the best way to store co-ordinates (longitude/latitude, from Google Maps) in SQL Server?
  25. Database design: Calculating the Account Balance
  26. Instead of trigger in SQL Server loses SCOPE_IDENTITY?
  27. INFORMATION_SCHEMA vs sysobjects
  28. Merge multiple rows into a single row
  29. Undesired rounding of DateTime in SQL Server
  30. How to choose the clustered index in SQL Server?

Leave a Comment