Mailing-List: contact ddlutils-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ddlutils-dev@db.apache.org
Message-ID: <28362017.1160596416910.JavaMail.jira@brutus>
Date: Wed, 11 Oct 2006 12:53:36 -0700 (PDT)
From: "Thomas Dudziak (JIRA)" <jira@apache.org>
To: ddlutils-dev@db.apache.org
Subject: [jira] Resolved: (DDLUTILS-40) Numeric formatting in MS SQL Server
In-Reply-To: <1758407052.1131005695937.JavaMail.jira@ajax.apache.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

     [ 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