问如何从临时表到Sql one数据库表中获取不同的记录

EN

INSERT INTO TestTbl (T1,T2,T3)  SELECT T1,T2,T3 from
(
Select Row_Number() over(Partition By T1 order By T1) as row,* from #Test
) a
 where a.row=1;

INSERT INTO TestTbl (T1,T2,T3)
SELECT Distinct(T1), T2, T3 FROM #Test

INSERT  INTO TestTbl
        ( T1 ,
          T2 ,
          T3
        )
        SELECT  T1 ,
                T2 ,
                T3
        FROM    ( SELECT    T1 ,
                            T2 ,
                            T3 ,
                            Row_Number() OVER ( PARTITION BY T1 ORDER BY T1) AS record
                            -- you need to select the relevant clause here for the order
                            -- do you want first or latest record? 
                  FROM      #Test
                ) tmp
        WHERE   tmp.record = 1 ;

SELECT DISTINCT column_name,column_name
FROM table_name

INSERT INTO table_name (column1,column2,column3,...)
VALUES (value1,value2,value3,...)