Hi,
I need a unique value for a composite key. I have created a little table that has an IDENTITY column. I inserts a record via StoredProc., And get as output parameters the SCOPE_IDENTITY ().
In a BulkInsert from a flat file, sometimes it comes at a high load to a DEADLOCK on this place....the procedure continues to run without having the key :w00t:
Is there a better method to get a UniqueKey quickly?
BestReagards
Nicole
😎