select * from table where datepart(month,ArrivalDateTime) =@month
create proc ppp @month int asselect * from table where Month(ArrivalDateTime)=@month
最好加上年份 create proc ppp @year int, @month int as select * from ta where datepart(year,ArrivalDateTime) =@year and datepart(month,ArrivalDateTime) =@month
create proc ppp @month int as select * from table where datepart(mm,ArrivalDateTime)=@month
create proc ppp (@month int) as begin select * from table where convert(char(6),ArrivalDateTime,112)='@month' --不知道ArrivalDateTime是什么格式的?上面convert(char(6),ArrivalDateTime,112)是取年月 end .... exec ppp '200811'
where datepart(month,ArrivalDateTime) =@month
create proc ppp
@month int
asselect * from table
where Month(ArrivalDateTime)=@month
create proc ppp
@year int,
@month int
as select * from ta
where datepart(year,ArrivalDateTime) =@year and
datepart(month,ArrivalDateTime) =@month
@month int
as select * from table
where datepart(mm,ArrivalDateTime)=@month
as
begin
select * from table
where convert(char(6),ArrivalDateTime,112)='@month'
--不知道ArrivalDateTime是什么格式的?上面convert(char(6),ArrivalDateTime,112)是取年月
end
....
exec ppp '200811'