SQL SERVER – Dividing of Two Integer to get Float Value

if you make simple devide you will get integer without round value so you need to cast int to float Ex :

    SELECT (CAST(Number1)AS FLOAT)/Number1) AS AnswerFloat1
    SELECT (CAST(Number1)AS FLOAT)/Number1) AS AnswerFloat1

1. <code>
2. SELECT (CAST(Number1)AS FLOAT)/Number1) AS AnswerFloat1
3. </code>

<code>
    SELECT (CAST(Number1)AS FLOAT)/Number1) AS AnswerFloat1
</code>