千金不卖

摘要： a:没有主键的情形： Select identity(int,1,1) as iid,* into #tmp from TableName Select * from #tmp Drop table #tmp b:有主键的情形： Select (Select sum(1) from TableName where KeyField <= a.KeyField) as iid,... 阅读全文