Sergiy (5/1/2016)

---

create table employee_id_mapping

(

employee_id bigint identity(1000000,1),

By using bigint here you're gonna just waste the system resources.

You may have 4 records in your database per every possible SSN number and still stay within the capacity of int data type.

That's if your company is gonna employ every USA citizen.

And for some reason, I do not think that's what is gonna happen.