change id to primary and auto increment sql server code example

Example: how to alter auto increment in sql

INSERT INTO Persons (Personid,FirstName,LastName)

VALUES (seq_person.nextval,'Lars','Monsen');