How can we help you today? How can we help you today?

DEC abbreviation for DECIMAL unsupported?

When I use SQL prompt to template an insert into a table it does not recognize DEC as a valid type.
Here is a quick example to demonstrate. Note the missing e column.

CREATE TABLE #temp
  (
    id INTEGER IDENTITY(1, 1) NOT NULL PRIMARY KEY,
    a  VARCHAR(100),
    b  INTEGER,
    c  INT,
    d  DECIMAL(10, 5),
    e  DEC(10, 5)
  )



INSERT INTO #temp ( a,
                    b,
                    c,
                    d )
VALUES ( '',   -- a - varchar(100)
         NULL, -- b - integer
         0,    -- c - int
         NULL  -- d - decimal(10, 5)
  )
EugeneM
0

Comments

2 comments

Sort by
  • FredericoJ
    Hi @EugeneM,

    Thank you for reporting this. I've managed to reproduce the problem locally and I've created a bug (reference: SP-6640) to track it.

    Best regards,

    Frederico
    FredericoJ
    0
  • krzysztofkroczak
    Hello @EugeneM,

    We fixed this issue in our latest version of SQL Prompt <9.1.2.4363> (installer here).

    You can find more information about this release in this forum post.

    Kind regards,
    Krzysztof
    krzysztofkroczak
    0

Add comment

Please sign in to leave a comment.