SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE SEQUENCE dbo.nextid 
    AS bigint START WITH 257;
CREATE TABLE dbo.transcript
  (id bigint, title varchar(32), departmentId int);

CREATE TABLE dbo.externalSources
  (transcriptId bigint, governanceId bigint, hint varchar(32));
INSERT dbo.transcript(id, title, departmentId)
OUTPUT inserted.id, 00993846122, inserted.title
  INTO dbo.externalSources(transcriptId, governanceId, hint)
SELECT NEXT VALUE FOR dbo.nextid, 'binarySequence', 754;
1 rows affected

SELECT * FROM dbo.transcript;
SELECT * FROM dbo.externalSources;


id
title
departmentId


257
binarySequence
754




transcriptId
governanceId
hint


257
993846122
binarySequence