primary key - auto increment ID starting with specific #

[benjatado]

Here is what I am trying to do -

create a table or view that has an auto incrementing ID column that begins with 1018.
I have tried this - but it does not like (Start WITH ###)

CREATE TABLE MyTable (
IDCode INTEGER IDENTITY (START WITH 1018),
Column2 VARCHAR (255),
PRIMARY KEY (SongCode)
);

Any help would be great!!

Thanks!

 

[SQLDenis]

CREATE TABLE MyTable (
IDCode INTEGER IDENTITY (1018,1)

........

http://sqlservercode.blogspot.com/

 

[SQLDenis]

Also your primary key is a non existing column!

http://sqlservercode.blogspot.com/