How can you assign a value to a SQL float data type?

10 months ago

Sophia Anderson

1 minute

In SQL, you can assign a value to a float type variable using the following syntax:

DECLARE @myFloat FLOAT
SET @myFloat = 123.45

You can also directly assign a float value to a column in an INSERT or UPDATE statement.

INSERT INTO myTable (myFloatColumn) VALUES (123.45)

Or return a float value as a result in the SELECT statement.

SELECT 123.45 AS myFloatColumn