Site icon Camas Para Perros 10

SQL server DEFAULT definitions

SQL server DEFAULT definitions

I am trying to learn SQL server and was referring to Instant SQL by Joe Celko. On Page 71 of the book he defines a table as is attached in my code, however I am getting an error saying that I have multiple default constraints.

Can someone please explain what it means and how to solve it?

CREATE TABLE Salespersons (
    empid INTEGER NOT NULL,
    ename CHAR(15) NOT NULL,
    erank INTEGER NOT NULL DEFAULT 1 CHECK (erank IN (1,2,3)),
    salary DECIMAL (7,2) NOT NULL DEFAULT 100.00
    DEFAULT 1000.00 CHECK (salary >= 1000.00)
)
Exit mobile version