hi ,
my Question is how to insert records between two id in sql server
for example :
i have Id like 1,2,3,4 in table ,I want to insert record on place of 2 and record of id 2 will swap down in place of 3 and 3 will swap down place of 4 and so on
how I can do this