>>>Is it possible to get an Identity/PK of a table without adding a record? Here is what I would like to do:
>>>
>>>1. Get Identity (next PK number) for a table.
>>>2. Add a record to a view/cursor.
>>>3. Once user commands to Save the record, add a row to the table using the PK that was obtained in step 1.
>>>
>>>Is it possible?
>>>
>>>Thank you.
>>
>>
>>GUID!!!!!
>
>The problem with GUID (I think in my case) is I want the identity in this particular table to be in sequential order and no numbers missing. And with GUID, as I understand, another "procedure" or "process" can grab the number.

Extremely, extremely unlikely!

Identity columns are not necessarily PKs. An Invoice # could be the invoice ID and should have no gaps. The PK should be different and used just for table joins.

>
>Thank you.