table datatype Problem

• Gopal Choudhury

  SSC Enthusiast

  Points: 199

  More actions

  August 2, 2007 at 3:20 am

  #118023

  DECLARE

  @table TABLE (primary_key INT IDENTITY(1,1) NOT NULL, Itm_ID INT, Itm_Desc varchar(1000))

  INSERT

  INTO @table VALUES(1,'123')

  INSERT INTO @table VALUES(2,'abc')

  delete

  @table

  --DBCC CHECKIDENT (@table)

  select

  * from @table

  can any one help me

  i was trying to reset the identity column but  it genetares error

  ??????????????????????????????????

  how to solve???????????????????

   

• SwePeso

  SSC-Dedicated

  Points: 39757

  More actions

  August 2, 2007 at 3:28 am

  #724112

  I don't think you can reseed table variables.

  CREATE

  table #table (primary_key INT IDENTITY(1,1) NOT NULL, Itm_ID INT, Itm_Desc varchar(1000))

  INSERT

  INTO #table VALUES(1,'123')

  INSERT

  INTO #table VALUES(2,'abc')

  delete

  #table

  DBCC

  CHECKIDENT (#table, reseed, 0)

  INSERT

  INTO #table VALUES(99,'peso')

  select

  * from #table

  drop

  table #table

   

  ---

  N 56°04'39.16"
  E 12°55'05.25"

• Vladan

  SSC-Insane

  Points: 22072

  More actions

  August 2, 2007 at 3:38 am

  #724114

  Table variable is just a variable - not a table. You can't use DBCC , you can't use TRUNCATE TABLE... just SELECT, INSERT, UPDATE, DELETE. I know of no way to reseed identity column in a table variable.