Float value

[Per9922]

Hello all,

What shoulen de syntax be if I would like to insert a float value in SQL table. I have tried this:

SQL_Table = "UPDATE TestTable SET TestElement = "& 10.8 &" WHERE SerialNo = '"& TestTag &"';"

What type should TestElement have ? How should the syntax be ?

Thanks
Olof

 

[djj55]

What does SQL_Table look like after this statement is executed.

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!

 

[markros]

You can use decimal(10,2) (or chose correct precision and scale) or float data type in SQL Server.

PluralSight Learning Library