In SQL Server, all you do is define a column as an integer (normally) ans specify that it is an identity column.

That's all there is.

Every time you insert a record into the table, the identity column with be incremented to a unique value. Normally you do not insert a value into an identity column - it populates automatically.

>Thanks for your reply. I am using the following method to generate primary key
>
>Begin Transaction
> SELECT PKTable
> RLOCK()
> Replace PK_Type_Field with PK_Type_Field + 1
> lnNewPK = PK_Type_Field
>
> * insert/update/etc
> * first Master table with lnNewPk
> * then Child table with lnNewPK
>
> * Now Rollback / Commit
>
> SELECT PKTable
> UNLOCK
>END TRANSACTION
>
>
>if I use the identity column as my primary key then how can I generate my Alternate Key as the above. What is the T-SQL for above code?
>
>TIA