Post reply

Insert Value into table

  • 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 "

  • 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

  • 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

  • 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.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply