这应该可以解决问题:

CREATE TABLE employee (
id INTEGER IDENTITY(1,1) PRIMARY KEY,
name VARCHAR(45) NOT NULL,
phone VARCHAR(45),
salary FLOAT DEFAULT 0 NOT NULL
);

当您插入此表时，从插入/选择列表中省略"id"，SQL Server将为您处理.

When you insert into this table, omit 'id' from the insert/select list, SQL Server will handle it for you.

例如:

INSERT INTO employee (name,phone,salary) 
VALUES ('Harry','9985099850',60000);