【正文】
INTO male_student FROM student WHERE gender=39。男39。第七章1.(1)USE 教學 GO CREATE PROC student_male AS SELECT * FROM student WHERE gender= 39。男39。 GO EXEC student_male(2)EXEC sp_helptext student_male(3)DROP PROC student_male USE 教學 GO CREATE PROC student_male (@gender char(2)= 39。男39。) AS SELECT * FROM student WHERE gender= @gender GO 2. (1)USE 教學GOCREATE TRIGGER student_UPDATE ON student FOR UPDATEAS UPDATE score SET sno=(SELECT sno FROM INSERTED) WHERE sno=(SELECT sno FROM DELETED)(2) CREATE TRIGGER student_DELETE ON student FOR DELETEAS DELETE FROM score WHERE = (SELECT sno FROM deleted) (3)EXEC sp_helptext student_UPDATEEXEC sp_helptext student_DELETEGO(4)DROP TRIGGER student_UPDATE, student_DELETE