Loading

Help with IDENTITY column error

Help with IDENTITY column error

Nel

8y1kLearn iOS Programming

Can anybody help me please where should I define identity for the primary key?

create table Employee(EmployeeID integer IDENTITY (1,1), FirstName varchar(20),

LastName varchar(20),Birthdate date, HomeState varchar(2),

Gender varchar(2), primary key(EmployeeID));

Thank you!

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bharathi Raja8y ago
accept the answer
0
Bharathi Raja8y ago
your Query:

create table Employee(EmployeeID integer IDENTITY (1,1), FirstName varchar(20),

LastName varchar(20),Birthdate date, HomeState varchar(2),

Gender varchar(2), primary key(EmployeeID));

Change The Line:

create table Employee(EmployeeID int IDENTITY (1,1), FirstName varchar(20),

LastName varchar(20),Birthdate date, HomeState varchar(2),

Gender varchar(2), primary key(EmployeeID));
+1
Nigel Fernandes8y ago
This is how your query should be:
CREATE TABLE dbo.Employee
    (
    EmployeeID int NOT NULL IDENTITY (1, 1),
    FirstName varchar(20) NULL,
    LastName varchar(20) NULL,
    Birthdate date NULL,
    HomeState varchar(2) NULL,
    Gender varchar(2) NULL
    )  ON [PRIMARY]
GO
ALTER TABLE dbo.Employee ADD CONSTRAINT
    PK_Employee PRIMARY KEY CLUSTERED
    (
    EmployeeID
    ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
0
Amit Gupta8y ago
Hey

Well, I generally prefer to use a seperate column for identity and primary key named ID

Keeping a seperate column will help you to uniquely identify your row for CRUD operations and it doesn't affect your any column.

Good Luck
0
Nel8y ago
Tried but didn't help
0