存储过程 写法

 strSQL = "exec daycount " + Session("grade") + ",'" + Session("police") + "','" + AToDay + "'"

CREATE Procedure daycount
@Grad int,
@police Varchar(10),
@currenttime varchar(20)

as
if @Grad=0
begin
select (select hotelname from info_hotel where info_hotel.hotelcode=Info_Guest.hotelcode) as hotelname,Count(guestcode) as UpDataNum from info_Guest where substring(LoginTime,1,8)=@currenttime and hotelcode in (select PH.hotelcode from Info_hotel as PH where PH.ting=@police and hotelstatus = 1) group by HotelCode  ORDER BY UpDataNum
end
  
GO

转载于:https://www.cnblogs.com/liufei88866/archive/2009/08/06/1540579.html