Reply to Re: Europe syntax for desimal

Your name:

Reply:


Posted by Dan Guzman on 03/18/07 16:13

> 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" <kaitsu@luukku.com> wrote in message
news:mH9Lh.84$MA3.36@read3.inet.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)
>

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация