-- ==========================================================================================
Select IDENTITY(int, 1,1) AS fNum, t.*
Into #Temp2
From #Temp1 t
Order By fArchivesID, fContractItemClassID, fCostItemID, fPlanDate数局是从这取的, 索引 怎么建
Select IDENTITY(int, 1,1) AS fNum, t.*
Into #Temp2
From #Temp1 t
Order By fArchivesID, fContractItemClassID, fCostItemID, fPlanDate数局是从这取的, 索引 怎么建
CREATE INDEX INDEX_NAME1 ON #TEMP1(COL)