• While I know you are not supposed to be able to add multiple GUIDs to any table, on the systems I have worked on I have found that with table variables it is possible. When I run the following I do not get any errors

    declare @TableVar table(MyID INT IDENTITY PRIMARY KEY CLUSTERED

    , NEXTFIELD varchar(10), nextfield2 varchar(10)

    , ROWGUID UNIQUEIDENTIFIER

    , ROWGUID2 UNIQUEIDENTIFIER

    )

    insert into @TableVar (NEXTFIELD, nextfield2, ROWGUID, ROWGUID2)

    values ('Test1', 'TEST1', NEWID(), NEWID())

    , ('Test2', 'TEST2', NEWID(), NEWID())

    , ('TEST3', 'HOW', NEWID(), NEWID())

    select * from @TableVar