Post reply

Chaning Identity of column through Stored Procedure.

  • September 5, 2006 at 8:13 pm

    #170135

    Hi group,

    Can you guys please let me know how do I change Identity of a column of a table through stored procedure? or in any other ways if possible? Is this possible at all? If given syntax, it is of great help. Thanks in advance.

  • September 5, 2006 at 9:17 pm

    #658684

    What do you mean "change Identity of a column of a table"?

    What exactly you are trying to do?

    _____________
    Code for TallyGenerator

  • September 5, 2006 at 9:25 pm

    #658688

    Table ABC - non of the columns are Identity

    Structure of ABC: RecID Int(4) - Not Identity

    Name varcahr(100)

    Address varchar(100)

    Now I have to insert Name and Address from table XYZ and increment values for RECID for every record inserted. Can you please let know how can I do that? Thanks in advance.

  • September 5, 2006 at 10:43 pm

    #658697

    Answered in parallel topic.

    _____________
    Code for TallyGenerator

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

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