Happy new year 2015 . Suppose you have a source table and one destination table (Which is exact replica of source table) and you want to copy all the rows of source table into destination table. Now the challenging part here is that there is an identity column and in source & destination table …
Sometimes, we may require to reseed identity column of a table due to various reason. For example we have deleted a record from a Student which have an identity column StudentId. Below is schema Now it has 3 rows as shown below Now suppose we have deleted record 3 which is studentID 3. Now …