select 敘述產生流水號

SELECT IDENTITY(int, 1,1) iduniq, id
into #tmp
FROM mytable
where schyy='98' and smt=2 and id like '00%' --條件可以自訂,在此不重要

select * from #tmp

drop table #tmp