CREATE procedure GetTeacher (@nMonth tinyint, @nYear smallint, @ggg nvarchar)
as
select * FROM vwPlan
where datepart(yy, begindate) =@nYear and datepart(mm,begindate) =@nMonth and ggg like '%'+@ggg+'%'
order by Begindate,startTime
GO
as
select * FROM vwPlan
where datepart(yy, begindate) =@nYear and datepart(mm,begindate) =@nMonth and ggg like '%'+@ggg+'%'
order by Begindate,startTime
GO
as
select * FROM vwPlan
where datepart(yy, begindate) =@nYear and datepart(mm,begindate) =@nMonth and ggg like '''%'+@ggg+'%'''
order by Begindate,startTime
GO---------''代表是’
下次给你加分吧