Returning the NewSequentialID() after Insert using the Output Clause

The basic idea:

create table foos(id uniqueidentifier primary KEY DEFAULT (newsequentialid()))

declare @Ids table(id uniqueidentifier)

insert foos
output inserted.id into @Ids
default values

select *
from @Ids

Is possible to use one auxiliar table, you can think about some temp table... This is one possible solution:

DECLARE @NewId UNIQUEIDENTIFIER
DECLARE @MyTableOutput TABLE
(
    AuxId int NOT NULL
    ,NewID UNIQUEIDENTIFIER DEFAULT NEWSEQUENTIALID()
)
INSERT INTO @MyTableOutput (AuxId) VALUES (1)
SELECT @NewId = NewID FROM @MyTableOutput
DELETE FROM @MyTableOutput

So you get your NewId to use in your INSERT, will work as one GEN_ID()

INSERT INTO MyTableFoos(MyId, MyValue...) VALUES (@NewId,'MyValue'...)

Your DEFAULT NEWSEQUENTIALID() will be on your TempTable, and your real table let without DEFAULT to your UNIQUEIDENTIFIER

You would use the other data that got inserted with the id to select it out again. So where you have the .. you would have:

SELECT id
WHERE ..

which would return the id