Æ®¸®°Å¶õ?
Å×ÀÌºí¿¡ µ¥ÀÌŸ°¡ Ãß°¡,»èÁ¦,º¯°æµÇ¾úÀ»¶§ ÀÚµ¿À¸·Î ¼öÇàµÇ´Â SQL¹®
¿¹Á¦:
CREATE TRIGGER score_insert ON [dbo].[CLASS_STUDENT]
FOR INSERT
AS
INSERT INTO SCORE
(sid, class, curriculum)
SELECT s.sid, s.class, c.curriculum
FROM Inserted s INNER JOIN
CLASS_CURRICULUM c ON s.class = c.class
¼³¸í :
CLASS_STUDENT ¿¡ µ¥ÀÌŸ°¡ Ãß°¡µÇ¾úÀ»¶§,
Ãß°¡µÈ µ¥ÀÌŸÀÇ class °ªÀÌ CLASS_CURRICULUM ¿¡ ÀÖ´Â class ¿Í °°Àº
°ÍÀ»À» SCORE Å×ÀÌºí¿¡ Ãß°¡ÇÑ´Ù.
Å×À̺í Á¤º¸ :
CLASS_STUDENT
class varchar(50)
sid varchar(50)
CLASS_CURRICULUM
class varchar(50)
curriculum varchar(50)
SCORE
sid varchar(50)
class varchar(50)
curriculum varchar(50)