CREATE PROCEDURE querytrain @Start varchar(20), @End varchar(20) , @Time_from datetime, @Time_to datetime AS SELECT Q.Train_id FROM RoutineRecord Q,RoutineRecord W WHERE Q.Station_name=@Start AND Q.Train_id=W.Train_id AND W.Station_name=@End AND W.Seq>Q.Seq AND W.Arrive_time BETWEEN @Time_from AND @Time_to
变量名前必须加@
如果不加就是invalid column name
@Start varchar(20),
@End varchar(20) ,
@Time_from datetime,
@Time_to datetime
AS
SELECT Q.Train_id
FROM RoutineRecord Q,RoutineRecord W
WHERE Q.Station_name=@Start
AND Q.Train_id=W.Train_id
AND W.Station_name=@End
AND W.Seq>Q.Seq
AND W.Arrive_time BETWEEN @Time_from AND @Time_to