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