Hi All

I have one table mast_diagnosis in sqlserver.Code is primary key in table.
Values are stored in Code like 1,2,3.....in sequence.

But MY problem is that I want to insert one row between 2 and 3 from frontend.How can i do that?

is it possible?Pls reply me if u know ans.

Thanks
monika

if datatype of code is int then its not possible
if datatype of code is like float you can do that

by using identity, identity seed, identity increment of columns

if you r doing this through coding
u can add as u want