regd default

• Sri8143

  SSCertifiable

  Points: 5251

  More actions

  August 18, 2008 at 10:17 am

  #75288

  i have 6 rows in a table

  so what i need to do is i will be inserting the data from other table into this table using sp ...

  so i have a column name sortorder in this table i need to have values as 1,2,3,4,5,6 so that i can sort by sortorder

  ...

  so when i delete the rows in my table and insert it again from other table i need to get the same 1,2,3,4,5,6 but i am getting 7,8,9,10,11,12

  Thanks,
  Chinna

  Its the Journey which gives you Happiness not the Destination-- Dan Millman

• Raghavendra-499237

  Default port

  Points: 1435

  More actions

  August 18, 2008 at 10:23 pm

  #859795

  Hi Rack,

  use truncate statement to delete rows instead of delete statement.

• karthik M

  One Orange Chip

  Points: 29139

  More actions

  August 19, 2008 at 2:39 am

  #859845

  Rack,

  Can you post your query here ?

  karthik