create trigger tia_st_role on ST_ROLE for insert as
begin
declare
@numrows int,
@numnull int,
@errno int,
@errmsg varchar(255)
select @numrows = @@rowcount
if @numrows = 0
return
INSERT INTO ST_ACCPRIORITY
( ROLE_Name, ACC_MenuName, ACC_MenuText,
ACC_ViewFlag, ACC_UpdateFlag,ACC_MenuItem1,
ACC_MenuItem2, ACC_MenuItem3, ACC_EnterDate,
ACC_OPerator,ACC_FLAG )
SELECT INSERTED.Role_name,ACC_MenuName, ACC_MenuText,
ACC_ViewFlag, ACC_UpdateFlag, ACC_MenuItem1,
ACC_MenuItem2, ACC_MenuItem3, ACC_EnterDate,
ACC_OPerator, 1
FROM ST_ACCPRIORITY,INSERTED WHERE ACC_FLAG = -1 --不知道楼主这里的业务逻辑是否正确。
if @@error<>0
goto error
else
return
/* Errors handling */
error:
raiserror @errno @errmsg
rollback transaction
end
go
begin
declare
@numrows int,
@numnull int,
@errno int,
@errmsg varchar(255)
select @numrows = @@rowcount
if @numrows = 0
return
INSERT INTO ST_ACCPRIORITY
( ROLE_Name, ACC_MenuName, ACC_MenuText,
ACC_ViewFlag, ACC_UpdateFlag,ACC_MenuItem1,
ACC_MenuItem2, ACC_MenuItem3, ACC_EnterDate,
ACC_OPerator,ACC_FLAG )
SELECT INSERTED.Role_name,ACC_MenuName, ACC_MenuText,
ACC_ViewFlag, ACC_UpdateFlag, ACC_MenuItem1,
ACC_MenuItem2, ACC_MenuItem3, ACC_EnterDate,
ACC_OPerator, 1
FROM ST_ACCPRIORITY,INSERTED WHERE ACC_FLAG = -1 --不知道楼主这里的业务逻辑是否正确。
if @@error<>0
goto error
else
return
/* Errors handling */
error:
raiserror @errno @errmsg
rollback transaction
end
go
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货