Would somebody share a SQL Server stored procedure that creates compound primary keys? I know how to do it in VFP but not T-SQL.

The first part of the key is a site number packed in two bytes and is kept in a one record table. The second part is a running number for each table, kept in a keys table, and packed into four bytes.

TIA,

Alex