直接用表触发器吧CREATE TRIGGER [TR_SERVICE_INSERT] ON [dbo].[SERVICES] FOR INSERT AS DELCARE @ID_INSERTED bigint SELECT @ID_INSERTED = ID FROM inserted -- 获得插入的服务ID-- 插入区域服务表 REGIONAL_SRV INSERT INTO REGIONAL_SRV (服务ID) VALUES (@ID_INSERTED)
谢谢了,可以的 让我奇怪的就是SELECT @ID_INSERTED = ID FROM inserted -- 获得插入的服务ID 这样能够获取服务的ID,让我很郁闷, 我以前是这样的 declare @card nvarchar(50) set @card = (select top 1 card from memberinfo order by id desc)
ON [dbo].[SERVICES]
FOR INSERT
AS
DELCARE @ID_INSERTED bigint
SELECT @ID_INSERTED = ID FROM inserted -- 获得插入的服务ID-- 插入区域服务表 REGIONAL_SRV
INSERT INTO REGIONAL_SRV
(服务ID)
VALUES
(@ID_INSERTED)
让我奇怪的就是SELECT @ID_INSERTED = ID FROM inserted -- 获得插入的服务ID
这样能够获取服务的ID,让我很郁闷,
我以前是这样的
declare @card nvarchar(50)
set @card = (select top 1 card from memberinfo order by id desc)