Options

DEC abbreviation for DECIMAL unsupported?

EugeneMEugeneM Posts: 2 New member
in SQL Prompt
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)
  )
Tagged:
· Share on Twitter

Answers

Sign In or Register to comment.