You are viewing a plain text version of this content. The canonical link for it is here.

Posted to ddlutils-dev@db.apache.org by "Thomas Dudziak (JIRA)" <ji...@apache.org> on 2006/10/11 21:53:36 UTC

[jira] Resolved: (DDLUTILS-40) Numeric formatting in MS SQL Server

     [ http://issues.apache.org/jira/browse/DDLUTILS-40?page=all ]

Thomas Dudziak resolved DDLUTILS-40.
------------------------------------

    Resolution: Fixed

Is applied, though I used the CAST function instead for the dates/times because this should also work with other JDBC drivers (as the driver does not evaluate the expression).

> Numeric formatting in MS SQL Server
> -----------------------------------
>
>                 Key: DDLUTILS-40
>                 URL: http://issues.apache.org/jira/browse/DDLUTILS-40
>             Project: DdlUtils
>          Issue Type: Bug
>          Components: Core - SqlServer
>            Reporter: JuanFran Adame Lorite
>         Assigned To: Thomas Dudziak
>            Priority: Minor
>             Fix For: 1.0
>
>         Attachments: MSSqlBuilder.java
>
>
> Numeric values does not have to be surrounded by quotes in SQL commands, doing so can generate errors when MS SQL Server parses a scientific format number (with quotes surrounding) to DECIMAL o NUMERIC column.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira