select identity(int,1,1) as lsh,* into #a from employee
go
select * from #a
Ls h emp_id fname minit lname job_id job_lvl pub_id hire_date
1 PMA42628M Paolo M Accorti 13 35 0877 1992-08-27 00:00:00.000
2 PSA89086M Pedro S Afonso 14 89 1389 1990-12-24 00:00:00.000
3 VPA30890F Victoria P Ashworth 6 140 0877 1990-09-13 00:00:00.000
4 H-B39728F Helen Bennett 12 35 0877 1989-09-21 00:00:00.000
5 L-B31947F Lesley Brown 7 120 0877 1991-02-13 00:00:00.000
6 F-C16315M Francisco Chang 4 227 9952 1990-11-03 00:00:00.000
7 PTC11962M Philip T Cramer 2 215 9952 1989-11-11 00:00:00.000
8 A-C71970F Aria Cruz 10 87 1389 1991-10-26 00:00:00.000
9 AMD15433F Ann M Devon 3 200 9952 1991-07-16 00:00:00.000
有了这个临时表和lsh,那么我们想用这个lsh做任何事情都可以了,排序等