Бред конечно, но вроде работает
CREARE TRIGGER [dbo].[SetDocNum]
ON [dbo].[_1SJOURN]
INSTEAD OF INSERT
AS
BEGIN
SET NOCOUNT ON
declare @IDJOURNAL as int
declare @IDDOC as char(9)
declare @IDDOCDEF as int
declare @APPCODE as smallint
declare @DATE_TIME_IDDOC as char(23)
declare @DNPREFIX as char(18)
declare @DOCNO as char(10)
declare @CLOSED as tinyint
declare @ISMARK as bit
declare @ACTCNT as int
declare @VERSTAMP as int
declare @DS51229 as tinyint
declare @DS52779 as tinyint
Select
@IDJOURNAL = IDJOURNAL,
@IDDOC = IDDOC,
@IDDOCDEF = IDDOCDEF,
@APPCODE = APPCODE,
@DATE_TIME_IDDOC = DATE_TIME_IDDOC,
@DNPREFIX = DNPREFIX,
@DOCNO = DOCNO,
@CLOSED = CLOSED,
@ISMARK = ISMARK,
@ACTCNT = ACTCNT,
@VERSTAMP = VERSTAMP,
@DS51229 = DS51229,
@DS52779 = DS52779
from
inserted
INSERT INTO
_1SJOURN (IDJOURNAL, IDDOC, IDDOCDEF, APPCODE, DATE_TIME_IDDOC,
DNPREFIX, DOCNO, CLOSED, ISMARK, ACTCNT, VERSTAMP, DS51229, DS52779)
VALUES (@IDJOURNAL, @IDDOC, @IDDOCDEF, @APPCODE, @DATE_TIME_IDDOC,
@DNPREFIX, @IDDOC, @CLOSED, @ISMARK, @ACTCNT, @VERSTAMP, @DS51229, @DS52779)
END