IF OBJECT_ID('TEMPDB..#BCROSSREFERENCE ') IS NOT NULLDROP TABLE #BCROSSREFERENCE IF OBJECT_ID('TEMPDB..#SCVTMP_BCUSTOMER') IS NOT NULLDROP TABLE #SCVTMP_BCUSTOMERIF OBJECT_ID('TEMPDB..#PDS_CREATE_SCV_TEMP') IS NOT NULLDROP TABLE #PDS_CREATE_SCV_TEMPIF OBJECT_ID('TEMPDB..#MASTER_NOTIN_LCSTSA') IS NOT NULLDROP TABLE #MASTER_NOTIN_LCSTSAIF OBJECT_ID('TEMPDB..#MASTER_NOTIN_LCSTCCG') IS NOT NULLDROP TABLE #MASTER_NOTIN_LCSTCCG

　　

ALTER TABLE #TEMP3 ADD ID INT IDENTITY(1,1)

给临时表加上自增ID