Thank you very much for your prompt response

Hi Lutz,

first of all I’m really happy to see a reply to my post. This is the second post which I drafted and for the first post I rally didn’t...

Hi all

if you wont to get the out put as -1,-2,-3

then the Question should be corrected as

create table MyTable (

mainKey int not null identity (-1,-1)

)

go

insert into myTable default...