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
Dipankar BiswasPosted May 4, 2015, 2:43 PM
check this link to help.http://www.sqlteam.com/article/how-to-insert-values-into-an-identity-column-in-sql-server