小白求助，如何把下面这两个sql语句合并成一个。。

[红魔鬼ncut]

sql1 = 'insert into environment_data(date,temperature) select ts,dbl_v from tb_kv_latest'
sql2 = 'select * from environment_data'

有前后顺序，需要先操作sql1再操作sql2，提前感谢各位大神！

[victor_yang]

Create procedure envData
as
insert into environment_data(date,temperature)
select ts,dbl_v from tb_kv_latest

select * from environment_data

[Dear SQL(燊)]

sql server 2005+ 如果只返回本次插入的记录

Create procedure envData
as
insert into environment_data(date,temperature) 
	output inserted.date,inserted.temperature
select ts,dbl_v from tb_kv_latest