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)
)