//CJ_Data储存
黑白简笔画>财高八斗
USE [XSCJ]
GO
CREATE PROCEDURE [dbo].[CJ_Data] (@in_xh char(9),@in_kch char(6),@in_cj int)
AS
DECLARE @in_count int
DECLARE @in_xf float
DECLARE @in_cjb_cj int
SET @in_xf = (SELECT 学分 from KCB WHERE 课程号=@in_kch)
SET @in_count = (SELECT COUNT(*) from CJB WHERE 学号=@in_xh AND 课程号=@in_kch)
SET @in_cjb_cj = (SELECT 成绩 from CJB WHERE 学号=@in_xh AND 课程号=@in_kch)
IF (@in_count>0)
经期能喝咖啡吗BEGIN
DELETE FROM CJB WHERE 学号=@in_xh AND 课程号=@in_kch
UPDATE KCB SET 选课人数=选课人数-1 WHERE 课程号=@in_kch
IF (@in_cjb_cj>=60)
BEGIN
丰富度的统计方法
UPDATE XSB SET 总学分=总学分- @in_xf WHERE 学号=@in_xh
END
END
IF(@in_cj!=-1)
BEGIN
INSERT INTO CJB VALUES(@in_xh,@in_kch,@in_j)
UPDATE KCB SET 选课人数=选课人数+1 WHERE 课程号=@in_kch关于火锅的诗句
IF (@in_cj>60)
BEGIN
UPDATE XSB SET 总学分=总学分+ @in_xf WHERE 学号=@in_xh
END
END
//XS_Data存储
USE [XSCJ]
GO
CREATE PROCEDURE [dbo].[XS_Data] (@in_xh char(9),@in_xm char(8),@in_xb bit,@in_birth datetime,@in_bjh char(6),@in_bz char(500))
合生元分销平台AS
DECLARE @in_count int
DECLARE @in_oldbjh char(6)
SET @in_count = (SELECT COUNT(*) from XSB WHERE 学号=@in_xh)
IF (@in_count>0)
BEGIN
SET @in_oldbjh = (SELECT 班级号 from XSB WHERE 学号=@in_xh)
UPDATE XSB SET 姓名=@in_xm，性别=@in_xb，出生时间=@in_birth，班级号=@in_bjh，备注=@in_bz
WHERE 学号=@in_xh
UPDATE BJB SET 班级人数=班级人数-1 WHERE 班级号=@in_oldbjh
UPDATE BJB SET 班级人数=班级人数+1 WHERE 班级号=@in_bjh
END
ELSE
BEGIN
INSERT INTO XSB (学号，姓名，性别，出生时间，总学分，班级号，备注)
VALUES (@in_xh,@in_xm,@in_xb,@in_birth,0，@in_bjh,@in_bz)
UPDATE BJB SET 班级人数=班级人数+1 WHERE 班级号=@in_bjh
END
//XS_DEL_Data存储
USE [XSCJ]张伯笠讲道
GO
CREATE PROCEDURE [dbo].[XS_DEL_Data] (@in_xh char(9),@in_bjh char(6))
AS
DECLARE @in_cjb_kch char(6)
DECLARE ur_cur cursor for SELECT 课程号 from CJB WHERE 学号=@in_xh
OPEN ur_cur
FETCH NEXT FROM ur_cur INTO @in_cjb_kch
WHILE (@@fetch_status=0)
BEGIN
DELETE FROM CJB WHERE 学号=@in_xh AND 课程号=@in_cjb_kch
UPDATE KCB SET 选课人数=选课人数-1 WHERE 课程号=@in_cjb_kch
FETCH NEXT FROM ur_cur INTO @in_cjb_kch
END
CLOSE ur_cur
DEALLOATE ur_cur
DELETE FROM XSB WHERE 学号=@in_xh
UPDATE BJB SET 班级人数=班级人数-1 WHERE 班级号=@in_bjh
//KC__Data存储
>红黄蓝绿
