tags:

views:

15

answers:

0

I have a sql table with a compound key. 1 field is int, the othe ris varchar. In my stored proc, when I insert a row, I want to use @@Identity to return the id (the int part of this key), but the fact that its a compound key is hosing me. How do I just return 1 field and not the entire key?