• Create Table MyTable( mainkey int not null identity (-1,1))

    GO

    insert into MyTable default values insert into MyTable default values insert into MyTable default values

    Select * from MyTable

    this will give result as this

    -1

    0

    1

    I think this type of question three weeks ago.this question is similar to the question on may 31 st 2010.

    Malleswarareddy
    I.T.Analyst
    MCITP(70-451)