>>Anyone know if it’s possible to get the value for an SQL server identify field before a transaction is completed.
>>
>>Basically I want to add a record to a table, get its PK value which is assigned in SQL server. Then add to some other tables and if everything goes well, commit the transaction to all tables.
>>
>>Thanks,
>
>You can use
SCOPE_IDENTITY( ) or @@Identity to get last identity value. See BOL for details and limitations of each.
Thanks,
I'll check it out
Chris