use pubsSELECT IDENTITY(smallint, 1, 1) AS job_num, emp_id AS emp_num, fname AS first, minit AS middle, lname AS last, job_lvl AS job_level, pub_id, hire_date INTO employees FROM employeeselect * from employees
select *,id=identity(int,1,1) into #t from tablenameselect * from #tdrop table #t
select *,id=identity(int,1,1) into #t from tablenameselect * from #tdrop table #t
emp_id AS emp_num,
fname AS first,
minit AS middle,
lname AS last,
job_lvl AS job_level,
pub_id,
hire_date
INTO employees
FROM employeeselect * from employees