毕业预警的SP
代码
create procedure sp_byyujing
as
declare @nj integer
--还剩下4年学籍无效,无通过门数少于5门
set @nj=year(getdate())
SELECT dwmc, xsjbdabplus.zymc, xsjbdabplus.bmc,xsjbdabplus.xh,xhjm, xsjbdabplus.xm,
xsjbdabplus.dh, byyshsdfb.wtgms, case when bysbxf <0 then 0 else bysbxf end as '必修', bysxif as '限修',case when bysxxf <0 then 0 else bysxxf end as '选修'
FROM byyshsdfb JOIN xsjbdabplus on byyshsdfb.xh=xsjbdabplus.xh
WHERE (@nj-cast(left(byyshsdfb.xh,4) as integer)>5) AND (byyshsdfb.wtgms < 5) AND
(xsjbdabplus.xjztdm = '1')
ORDER BY dwmc,bmc,byyshsdfb.xh
GO
as
declare @nj integer
--还剩下4年学籍无效,无通过门数少于5门
set @nj=year(getdate())
SELECT dwmc, xsjbdabplus.zymc, xsjbdabplus.bmc,xsjbdabplus.xh,xhjm, xsjbdabplus.xm,
xsjbdabplus.dh, byyshsdfb.wtgms, case when bysbxf <0 then 0 else bysbxf end as '必修', bysxif as '限修',case when bysxxf <0 then 0 else bysxxf end as '选修'
FROM byyshsdfb JOIN xsjbdabplus on byyshsdfb.xh=xsjbdabplus.xh
WHERE (@nj-cast(left(byyshsdfb.xh,4) as integer)>5) AND (byyshsdfb.wtgms < 5) AND
(xsjbdabplus.xjztdm = '1')
ORDER BY dwmc,bmc,byyshsdfb.xh
GO
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步