It is not possible to create two id columns in a single talbe practically. But i will show you the trick. Just use the below query
create table pinsAbove query create two id columns "pin" and "pin_id".
cust_id int not null
,pin as reg_cust_id * 789 + 7598755
,pin_id int identity(789452,198789) not null primary key
,transferee_id int null
,transferee_date datetime null
Keep Coding and stay in touch with SetpCoder.com.