SQL Server 2022

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

CREATE VIEW MyView
AS
SELECT
    NEWID() as RowId1,
    ISNULL(NEWID(), 0x0) as RowId2,
    ROW_NUMBER() OVER(ORDER BY (SELECT NULL)) as RowNum1,
    ISNULL(ROW_NUMBER() OVER(ORDER BY (SELECT NULL)), 0) as RowNum2,
    A.Value
FROM (
    VALUES ('aaa'), ('bbb'), ('ccc')
) A(Value)
SELECT C.COLUMN_NAME, C.DATA_TYPE, C.IS_NULLABLE
FROM INFORMATION_SCHEMA.COLUMNS C
WHERE C.TABLE_NAME = 'MyView'
ORDER BY C.ORDINAL_POSITION


COLUMN_NAME
DATA_TYPE
IS_NULLABLE


RowId1
uniqueidentifier
YES

RowId2
uniqueidentifier
NO

RowNum1
bigint
YES

RowNum2
bigint
NO

Value
varchar
NO


SELECT *
FROM MyView


RowId1
RowId2
RowNum1
RowNum2
Value


9bedb751-42d5-4319-9af7-6497faa44c67
075c57fc-a799-4d95-bcc7-d4b8d6ecfaf0
1
1
aaa

d139a902-947b-4e53-a047-f205217b9837
04211c9c-06c4-45c9-875d-a28539e19e4e
2
2
bbb

d6dc0d57-7a85-47ae-8b3b-ad15a7b45ae7
6c25ee5d-8555-47ea-a1a0-2c8c540fdc81
3
3
ccc

COLUMN_NAME	DATA_TYPE	IS_NULLABLE
RowId1	uniqueidentifier	YES
RowId2	uniqueidentifier	NO
RowNum1	bigint	YES
RowNum2	bigint	NO
Value	varchar	NO

RowId1	RowId2	RowNum1	RowNum2	Value
9bedb751-42d5-4319-9af7-6497faa44c67	075c57fc-a799-4d95-bcc7-d4b8d6ecfaf0	1	1	aaa
d139a902-947b-4e53-a047-f205217b9837	04211c9c-06c4-45c9-875d-a28539e19e4e	2	2	bbb
d6dc0d57-7a85-47ae-8b3b-ad15a7b45ae7	6c25ee5d-8555-47ea-a1a0-2c8c540fdc81	3	3	ccc