This works:

cREATE TABLE #test (
[Testløbenr] [int] IDENTITY (5000,1) NOT NULL ,
[Indhold] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)


insert into #test
(Indhold)
select 'def'

.....and this don't:

declare @max as int

select @max = 5000

CREATE TABLE #test (
[Testløbenr] [int] IDENTITY (@max,1) NOT NULL ,
[Indhold] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)

insert into #test
(Indhold)
select 'def'

Is there another way of controlling the starting number in the temp-table ?

Got it solved by making an extra column wich I update afterwards...
"Michael Vardinghus" <michaelvardinghus (AT) hotmail (DOT) com> wrote