Thanks Gail Shaw, Can you give some reference for the same or please give some example how it will work?

Thanks in advance.

---

Karthik

I think the question is wrong.

incase identity(-1,-1) then the answer ll be correct other wise will get -1,0,1 only.

Thanks for your reply guys. but what i need is, i dont know the tablename in the database. means that db having more no.of tables. so from those tables i...

I am having those fields in my table.

consider the table having the following columns,

ID int identity(1,1) PK,

Name nvarchar(25)

named as table1 and the same fields and some additional fields also there...