create proc oil (@TruckNo nvarchar(20))as begin select TruckNo as 车牌号,SUM(oil) AS 加油量,SUM(ThisKM-AgoKM)as 公里数,SUM(Oil)/SUM(ThisKM-AgoKM) as 百公里油耗 from Oil where TruckNo=@TruckNo group by TruckNo end
create proc oil (@TruckNo nvarchar(20))as begin select TruckNo as 车牌号,SUM(oil) AS 加油量,SUM(ThisKM-AgoKM)as 公里数,SUM(Oil)/SUM(ThisKM-AgoKM) as 百公里油耗 from Oil <span style="color: #FF0000;">where TruckNo=@TruckNo</span> group by TruckNo end
create proc oil (@TruckNo nvarchar(20))as begin select TruckNo as 车牌号,SUM(oil) AS 加油量,SUM(ThisKM-AgoKM)as 公里数,SUM(Oil)/SUM(ThisKM-AgoKM) as 百公里油耗 from Oil where TruckNo=@TruckNo group by TruckNo end
where 条件后 指定 字段 :车牌=输入参数 。 这里 where TruckNo=@TruckNo
begin
select TruckNo as 车牌号,SUM(oil) AS 加油量,SUM(ThisKM-AgoKM)as 公里数,SUM(Oil)/SUM(ThisKM-AgoKM) as 百公里油耗 from Oil <span style="color: #FF0000;">where TruckNo=@TruckNo</span> group by TruckNo
end
begin
select TruckNo as 车牌号,SUM(oil) AS 加油量,SUM(ThisKM-AgoKM)as 公里数,SUM(Oil)/SUM(ThisKM-AgoKM) as 百公里油耗 from Oil where TruckNo=@TruckNo group by TruckNo
end
这里 where TruckNo=@TruckNo