>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.
>
Sure it's possible but not with IDENTITY column. You can use uniqueidentifier(GUID) or see
Re: Record ID generator question Thread #
605839
--sb--