CREATE VIEW V1_STU 
AS
SELECT * FROM Student WHERE Class_ID='911193'

CREATE VIEW V2_STU 
AS
SELECT * FROM Student WHERE Class_ID='911194'

CREATE VIEW V3_STU 
AS
SELECT * FROM Student WHERE Class_ID='911194'

SELECT Student_ID,BIRTHDAY FROM V2_STU WHERE GENDER='女'


INSERT INTO V1_STU VALUES('024631267','911193','刘明仪','男','1982-3-2','南昌','830052','刘林');

DROP VIEW V3_STU

CREATE INDEX STU_IND ON Student(Student_ID)

CREATE TRIGGER age_student on Student FOR UPDATE AS IF(SELECT COUNT(*) FROM INSERTED WHERE SAGE<10)>0
BEGIN
PRINT '注意：当前修改的年龄（Age）属性不大于10，请重新输入符合要求的字段值。'
ROLLBACK TRANSACTION
END
ELSE
PRINT '您修改的年龄（Age）属性值符合修改要求，成功完成修改操作。'

CREATE PROCEDURE STUDENTAdd
(@STUDENT_ID CHAR(9), @CLASS_ID CHAR(7), @NAME CHAR(24), @GENDER CHAR(2), @BIRTHDAY DATETIME, 
	@ADDRESS CHAR(24), @ZIP_CODE decimal(6, 0), @HOUSEHOLDER CHAR(20),@SAGE INT)
AS
BEGIN
INSERT INTO Student
VALUES(@STUDENT_ID,@CLASS_ID,@NAME,@GENDER,@BIRTHDAY,@ADDRESS,@ZIP_CODE,@HOUSEHOLDER,@SAGE)
END
RETURN


USE 张俊杰2019901482
EXEC STUDENTAdd '024632344','911193','张芸','女','2001-01-01','南昌路43号','83052','张峰','20'
GO