getting identity columns
Posted: Wed Nov 30, 2005 1:38 pm
Hi guys,
I have a job that determines the inserts. our target table generates the id on the database level when an insert command is issued to it. Once my inserts are successful and the ids are generated, i have to get that id and use that id to update the mapping table. The problem is that my target table has only one key that the database generates.
what would be the best approach to get that key.
anyone faced such a scenario before.
Thanks in advance guys
I have a job that determines the inserts. our target table generates the id on the database level when an insert command is issued to it. Once my inserts are successful and the ids are generated, i have to get that id and use that id to update the mapping table. The problem is that my target table has only one key that the database generates.
what would be the best approach to get that key.
anyone faced such a scenario before.
Thanks in advance guys