Insert Value into table

• sanjay s jadhav

  SSC Rookie

  Points: 29

  More actions

  November 22, 2006 at 3:40 am

  #67887

  Hi,

  How to insert a value into a table which is having only one column of identity type by using a SQL query " Insert into "

• ijaz

  SSCommitted

  Points: 1912

  More actions

  November 22, 2006 at 3:50 am

  #673407

  Hi,

  You should consider you database design why you are using the one column table having the identity field.

  You should make the entry into the table by Making the Identity Insert ON/OFF.

  for this you can use

  SET IDENTITY_INSERT YourTableName ON

  INSERT INTO products (id) VALUES(3)

  SET IDENTITY_INSERT YourTableName OFF

  Cheers

  cheers

• ijaz

  SSCommitted

  Points: 1912

  More actions

  November 22, 2006 at 3:51 am

  #673409

   

  Hi,

  You should consider you database design why you are using the one column table having the identity field.

  You should make the entry into the table by Making the Identity Insert ON/OFF.

  for this you can use

  SET IDENTITY_INSERT YourTableName ON

  INSERT INTO YourTableName (id) VALUES(3)

  SET IDENTITY_INSERT YourTableName OFF

  Cheers

  ---

  Kindest Regards,

  cheers

• bledu

  SSChampion

  Points: 12335

  More actions

  November 22, 2006 at 5:01 am

  #673414

  i agree with rao, why would you want a one column table. reconsider your db design or you can post your requirement to see if we can help

  ---

  Everything you can imagine is real.