Home Forums SQL Server 7,2000 T-SQL Using new Identity in new insert (other table) RE: Using new Identity in new insert (other table)

  • January 28, 2004 at 3:18 pm

    #492079

    I'm sorry, but I can do not completely understand your post. Are you executing SQL1, SQL2, SQL3 all in same script, one after the other?

    Whay can't SQL3 be:

    INSERT INTO  [UserID] ([User_Id],[MasterOverride], [ConfigurationId])  

    VALUES (IDENT_CURRENT('[UserList]'), c_MasterOverride , c_ConfigurationId

     



    Once you understand the BITs, all the pieces come together