Europe syntax for desimal

[Kaitsu]

What is the easiest way to solve "," problem

Fields A, B and C are float-values

INSERT INTO Table
(A, B, C)
VALUES (1,2,3)

This is ok, but. How can I insert values A=1,1 B=2,2 C=-11,123

This is not working

INSERT INTO Table
(A, B, C)
VALUES (1,1, 2,2 -11,123)

[Dan Guzman]

This is ok, but. How can I insert values A=1,1 B=2,2 C=-11,123

>
This is not working

INSERT INTO Table
(A, B, C)
VALUES (1,1, 2,2 -11,123)

You need to specify a decimal point as the decimal separator in SQL
literals:

INSERT INTO Table
(A, B, C)
VALUES (1.1, 2.2, 11.123)
--
Hope this helps.

Dan Guzman
SQL Server MVP

"Kaitsu" <ka****@luukku. comwrote in message
news:mH******** *****@read3.ine t.fi...

What is the easiest way to solve "," problem

Fields A, B and C are float-values

INSERT INTO Table
(A, B, C)
VALUES (1,2,3)

This is ok, but. How can I insert values A=1,1 B=2,2 C=-11,123

This is not working

INSERT INTO Table
(A, B, C)
VALUES (1,1, 2,2 -11,123)