CREATE TRIGGER Insert_TeOrStON on KD_User AFTER INSERT ,UPDATE
AS
declare @Us_id int,
@UserName nvarchar(50),
@TrueName nvarchar(50),
@gp_id int
select @Us_id=Us_id,@UserName=UserName,@TrueName=TrueName,@gp_id=gp_id from insertedIF (@gp_id=1)
BEGIN
insert into KD_Student VALUES(@Us_id,@UserName,@TrueName)
end
else if (@gp_id=2)
begin
insert into KD_Teacher VALUES(@Us_id,@UserName,@TrueName)
end
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货