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) 1 1392
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.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) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: MarionEll |
last post by:
XML Europe 2004, http://www.xmleurope.com, 18-21 April, at the Rai Centre
Amsterdam, provides the premier European forum for the XML community, spanning
the worlds of electronic business,...
|
by: MarionEll |
last post by:
Leading XML Vendors to Showcase Technologies, Solutions at XML Europe 2004
Pre-registration deadline 9 April
http://www.xmleurope.com
Alexandria, Va. - XML Europe 2004, the premier...
|
by: MarionEll |
last post by:
Leading Netherlands Firms, Industry Experts
in Spotlight at XML Europe 2004
Alexandria, Va. - April 13, 2004 - XML Europe 2004, the premier European forum
for the XML community, will feature...
|
by: Marcel - IDUG Europe 2004 |
last post by:
Dear DB2 user,
My name is Marcel Lévy and I'm a member of the IDUG 2004 Europe
Conference Planning Committee.
Mark your calendars and make plans to attend...
IDUG 2004 Europe
11-14 October...
|
by: Marcel - IDUG Europe 2004 |
last post by:
Dear DB2 user,
Attend IDUG 2005 - Europe for FREE!
Are you interested in attending IDUG 2005 - Europe at no cost?
http://conferences.idug.org/europe/2005/index.cfm
Accelerate your career by...
| |
by: Marcel - IDUG Europe 2005 |
last post by:
Dear DB2 user,
My name is Marcel Lévy and I'm a member of the IDUG 2005 Europe
Conference Planning Committee.
*********************************************************************
Mark your...
|
by: Marcel - IDUG Europe 2005 |
last post by:
Dear DB2 user,
My name is Marcel Lévy and I'm a member of the IDUG 2005 Europe
Conference Planning Committee.
*********************************************************************
Mark your...
|
by: Marcel - IDUG Europe 2005 |
last post by:
Last Chance to Register Online for IDUG 2005 - Europe - Register Today
Online registration closes this Friday, 14 October.
https://conferences.idug.org/secure/europe/2005/regform.cfm
...
|
by: Marcel - IDUG Europe 2006 |
last post by:
Important Announcement: IDUG 2006 - Europe Location and Dates Have
Changed!
Due to a schedule conflict with IBM's recently announced consumer
conference "Information On Demand Global...
|
by: Marcel - IDUG Europe 2006 |
last post by:
"Go Further" at IDUG 2006 - Europe for FREE!
http://conferences.idug.org/europe/2006/
Are you interested in attending IDUG 2006 - Europe at no cost?
The International DB2 Users Group (IDUG®)...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |