Trigger 'hn_LinkCheckExternal_Source'
if exists (select name from sysobjects where name = 'hn_LinkCheckExternal_Source' and type = 'TR')
drop trigger hn_LinkCheckExternal_Source
go
/*
** Triggers insertion of new links (source)
*/
create trigger hn_LinkCheckExternal_Source
on HDS_PUB_LINK_INFO
after insert
as
declare @INS_DOC_UNID varchar(64)
declare @INS_SEQNUM smallint
declare @INS_LINK_TYPE varchar(16)
declare @INS_LINK_CONFIGTYPE nvarchar(16)
declare @INS_PARAM1 nvarchar(384)
declare @INS_PARAM2 nvarchar(384)
declare @INS_PARAM3 nvarchar(384)
declare @INS_PARAM4 nvarchar(384)
select
@INS_DOC_UNID = DOC_UNID,
@INS_SEQNUM = SEQNUM,
@INS_LINK_TYPE = LINK_TYPE,
@INS_LINK_CONFIGTYPE = LINK_CONFIGTYPE,
@INS_PARAM1 = PARAM1,
@INS_PARAM2 = PARAM2,
@INS_PARAM3 = PARAM3,
@INS_PARAM4 = PARAM4
from inserted
EXECUTE hn_LinkCheckExternal
@INS_DOC_UNID OUTPUT,
@INS_SEQNUM OUTPUT,
@INS_LINK_TYPE OUTPUT,
@INS_LINK_CONFIGTYPE OUTPUT,
@INS_PARAM1 OUTPUT,
@INS_PARAM2 OUTPUT,
@INS_PARAM3 OUTPUT,
@INS_PARAM4 OUTPUT
go