崔好好

摘要： 1 --如果临时数据库存在名为#t的临时表则删除 2 if object_id('tempdb..#t') is not null 3 drop table #t; 4 5 6 SELECT * into #t FROM ( 7 select tbl_Pipe.pipeStartPoint from tbl_Pipe 8 union 9 select tbl_Pipe.pipeEndPoint from tbl_Pipe ) k ;10 --上面的k仅仅是让语法合法;11 12 select pipeStartPoint as allPoints, tbl_Poin... 阅读全文