CREATE TRIGGER 昨夜小楼 ON dbo.车辆表 FOR INSERT
ASSET NOCOUNT ON
--假设:车辆表(车辆ID int, 座位数 int)
--假设:座位表(车辆ID int, 座位号码 int)
DECLARE @车辆ID int, @座位数 int, @座位号码 int
SELECT @车辆ID = 车辆ID, @座位数 = 座位数, @座位号码 = 1 FROM INSERTED
WHILE @座位号码 <= @座位数
BEGIN
INSERT 座位表 SELECT 车辆ID, @座位号码
SET @座位号码 = @座位号码 + 1
END
SET NOCOUNT OFFGO
ASSET NOCOUNT ON
--假设:车辆表(车辆ID int, 座位数 int)
--假设:座位表(车辆ID int, 座位号码 int)
DECLARE @车辆ID int, @座位数 int, @座位号码 int
SELECT @车辆ID = 车辆ID, @座位数 = 座位数, @座位号码 = 1 FROM INSERTED
WHILE @座位号码 <= @座位数
BEGIN
INSERT 座位表 SELECT 车辆ID, @座位号码
SET @座位号码 = @座位号码 + 1
END
SET NOCOUNT OFFGO
FOR INSERT
ASSET NOCOUNT ON
--假设:车辆表(车辆ID int, 座位数 int)
--假设:座位表(车辆ID int, 座位号码 int)
DECLARE @车辆ID int, @座位数 int, @座位号码 int
SET @座位号码=1
SELECT @车辆ID=车辆ID,@座位数 = 座位数 FROM 车辆表
WHILE @座位号码 <=@座位数
BEGIN
INSERT INTO 座位表(车辆ID ,座位号码)
VALUES(@车辆ID,@座位号码)
SET @座位号码 = @座位号码 + 1
END
SET NOCOUNT OFF
GO