触发器小知识

CREATE TRIGGER tr_Chufaqi
ON Student FOR INSERT AS
DECLARE @sid INT
SELECT @sid =ID FROM inserted
INSERT INTO Score VALUES (@sid,90)
Go