CREATE TRIGGER when_include ON includes FOR insert AS declare @game_added int select @game_added = gid from INSERTED update games set gstatus = 'out' where gid = @game_added update games set gtimeshired = gtimeshired + 1 where gid = @game_added