sql server创建存储过程

create procedure PRO_RAIN_HOURS
  @tm datetime      
  as
  begin
      select a.stcd ,a.rn, b.测站名称 from (SELECT stcd,sum(rn) as rn FROM [dbo].[Rain_RealTime] where tm >=@tm GROUP BY stcd)a join VW_StationInfo b on a.stcd =b.测站代码 where b.[启用标志]=1
  end