decimal point problem in numeric constants

Topics: Database Publishing Wizard
Nov 8, 2006 at 1:05 PM
The 0.1.0.0 beta release of SQL Server Database Publishing Wizard CTP 1 produces the following INSERT statements from a test database of mine:

/****** Object: Table dbo.TestNumerics Script Date: 11/08/2006 13:32:24 ******/
TRUNCATE TABLE dbo.TestNumerics
SET IDENTITY_INSERT dbo.TestNumerics ON
INSERT dbo.TestNumerics (tstn_id, tstDecimal_18_2) VALUES (1, CAST(34,20 AS Decimal(18, 2)))
INSERT dbo.TestNumerics (tstn_id, tstDecimal_18_2) VALUES (2, CAST(12,00 AS Decimal(18, 2)))
INSERT dbo.TestNumerics (tstn_id, tstDecimal_18_2) VALUES (3, CAST(124,00 AS Decimal(18, 2)))
INSERT dbo.TestNumerics (tstn_id, tstDecimal_18_2) VALUES (4, CAST(134,00 AS Decimal(18, 2)))
SET IDENTITY_INSERT dbo.TestNumerics OFF

This does not work, because of the comma used as decimal point in the numeric constants. (T-SQL does not accept european notation for numeric constants, to my knowledge)

--
jensen
Nov 8, 2006 at 5:27 PM
Thanks for the feedback. This looks like a bug... we will fix it in the next release.

Regards,
alex