SQL 使用 VALUES AS生成带数据的临时表

--多列
select * into #tmpTable2 FROM (
  VALUES (1,2,3,4,123456)
        ,(2,3,4,5,123456)
        ,(3,4,5,6,123456)
        ,(4,100,100,3,123456)
        ,(23,4,5,5,123456)
) AS T(c1,c2,c3,c4,c5)

select *  from #tmpTable2    

--单列
select * into #tmpTable FROM (
  VALUES (123456),(123456),(123456),(123456),(123456)
) AS T(c1)

--直接显示数据
SELECT * FROM (
　　VALUES (123456),(123456),(123456),(123456),(123456)
) AS T(c1)